Friday, March 30, 2012

Migrating Foxpro table with memo fields to SQL Server

Hi Everyone,
Here is the issue : Getting error while transferring
foxpro data with memo fields. If I omit memo field, its
fine.
Could anyone know, how can I overcome this issue ?
Thanks in advance,
SKHow are you importing the data? Which version of FoxPro? What's the error
message?
The Visual FoxPro ODBC Driver supports memo fields (upto at least Fox 6.0)
and the DTS Import Wizard will automatically import them as Text columns if
you let it create the table for you. Fox 7.0 and 8.0 come with the newer
OLEDB driver. I haven't tried it with memo fields in DTS but I would expect
it to support Memo since the older driver does.
--
David Portas
--
Please reply only to the newsgroup
--

1 comment:

Macrosoft said...

Great information for migrating foxpro table.

Foxpro to .net

Post a Comment