Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Converting data to DBF format

Author  Topic 

Darren Smith
Starting Member

2 Posts

Posted - 2005-11-28 : 15:06:24
I am not a programmer, but I use SQL Data Transformation Services to export files from SQL into DBF format so I can use them in Microsoft
Visual Foxpro 6.0. I have no problem exporting most of the data, however, if I try to export a field that is larger than 254 characters into a memo field, I get the following error message:

"Query-based insertion or updating of BLOB values is not supported."

I would appreciate it if you could let me know of any way to work
around this problem of if there is any utility program that I could use.

Thanks so much for your help, and best regards.

Darren Smith
   

- Advertisement -