I need to import (on a regular basis) paradox (version 7) "binary" data into
an sql server 2000 database.

I am having a hard time finding information (via newsgroup / web searches)

What datatype *should* I use to represent the paradox binary data in sql
server?
I tried using the Image datatype as it is the only binary data type that is
equivalent to the max size of the paradox binary type (256 MB)

Also: I tried using DTS to import some data to see if it would work or not -
but it keeps ignoring my binary blobs.

Any help/suggestions would be greatly appreciated

Thanks for your time,
--
Melanie Cey
Programmer/Analyst
Traxis Inc.
Saskatoon, SK. Canada
ICQ#6002085

Probably you need to do little bit manual job.
Use Table1 as Paradox Table and make it active.
Use DBMemo to each of your Paradox Memo fields.
Use Query1 for your SQL table and make it Live.
Now use the following Code :

Table1.First;
while not Table1.Eof do
begin
     Query1.Insert;
     Query1.FieldByName('RegField1').Value :=
Table1.FieldByName('RegField1').Value;

     Query1.FieldByName('MemoField1').Value := DBMemo1.Text;
     Query1.FieldByName('MemoField2').Value := DBMemo2.Text;
     Query1.FieldByName('MemoField3').Value := DBMemo3.Text;
     Query1.Post;
     Table1.Next;
end;
end;