How to Import foxpro tables to Sql server using DTS

[VenkatSQL]

Hi

Our client is going to migrate all the data from Foxpro 2.6 and also Visual Foxpro tables to SQL Server 2000. I am trying to do using DTS package..

and also help me how to get/extract memo fields into SQL tables

Can any one help me on this..?


Thanks

venkatSQL

 

[AlexCuse]

Under connections, if you select "other" you should be able to specify the fox pro driver (I have a bunch of them, not sure which if any ship with SQL Server though). If worst comes to worst you should be able to use ODBC I would think.

If you can confirm there is nothing > 8000 characters in the memo column you can use a varchar(8000) column, otherwise I think you would need to use a text column (I don't know much about these, but would not recommend it).

Hope this helps,

Alex



[small]----signature below----[/small]
Majority rule don't work in mental institutions

My Crummy Web Page