Importing Paradox 5.x Blob field into SQL Server 2000

Richard Schuder

Delphi Developer

Mon, 12 Jul 2004 09:38:57 GMT

Importing Paradox 5.x Blob field into SQL Server 2000

I'm having a 'time' trying to import a blob field that contains text into a
table in Microsoft SQL Server 2000. It's beyond me why the original
database developer used a blob field when it contains nothing more than text
(<50 characters).

Any help would be appreciated.

Bill

Delphi Developer

Mon, 12 Jul 2004 20:46:40 GMT

Re:Importing Paradox 5.x Blob field into SQL Server 2000

If you know there is less then say 255 chars convert a copy of the table
(better safe then sorry) to an a255 field in Paradox, should be no problem.

Quote

"Richard Schuder" <rschu...@visudev.com> wrote in message

news:3c4f65b2$1_2@dnews...

Quote

> I'm having a 'time' trying to import a blob field that contains text into
a
> table in Microsoft SQL Server 2000. It's beyond me why the original
> database developer used a blob field when it contains nothing more than
text
> (<50 characters).

> Any help would be appreciated.

Richard Schude

Delphi Developer

Tue, 13 Jul 2004 03:45:11 GMT

Re:Importing Paradox 5.x Blob field into SQL Server 2000

That was my first idea. But the field type is F20 (Formatted Memo of size
20) and I could not convert directly from F to A.

I was able to convert the F to M (Memo). But when I tried converting M to
A, I lost all the data in the field.

Quote

"BillB" <Bill.NoSpam.Be...@Integic.com> wrote in message

news:3c50021b_1@dnews...

Quote

> If you know there is less then say 255 chars convert a copy of the table
> (better safe then sorry) to an a255 field in Paradox, should be no
problem.

> "Richard Schuder" <rschu...@visudev.com> wrote in message
> news:3c4f65b2$1_2@dnews...
> > I'm having a 'time' trying to import a blob field that contains text
into
> a
> > table in Microsoft SQL Server 2000. It's beyond me why the original
> > database developer used a blob field when it contains nothing more than
> text
> > (<50 characters).

> > Any help would be appreciated.

Other Threads

1. Paradox Bytes field to SQL Server 2000 int field

2. importing Blob/Memo field to SQL Server 7.0

3. Problem importing SQLDMO for SQL Server 2000

4. SQL Server 2000 and BLOBS

5. saving Word 97/2000 documents in a blob field (MS SQL 6.5)

6. Transferring data from SQL Server 2000 to Paradox

7. paradox binary type to sql server 2000 ...

8. Using SQL Server 2000 DTS to retrieve Paradox data

9. Sql Server 2000 & Sql Server 7.0

10. SQL Server 2000 isn't returning text fields