transfer data from foxpro to sql server

[Vineet]

i have an old database in foxpro. The table in foxpro now has been broken into more than tables in sql server 6.5 . how do i append the data to sql server database to the respective tables from the foxpro database.
vineet

[William Marra]

The easiest way is probably by using MS Access, especially if this is a
one-time deal. Depending on the version of Access you have, you should be
able to import from the FoxPro tables -- otherwise, you can export the Fox-Pro
tables as ASCII and bring them into Access.

If this was going to be an ongoing process, with data moving back and forth
between FoxPro and SQL Server, then I would suggest you set up an ODBC
connection, and write a small routine to upload records to the SQL database.

Email me if you want details on this -- it's not that difficult.

Bill



------------
Vineet at 6/11/99 8:39:17 AM

i have an old database in foxpro. The table in foxpro now has been broken into more than tables in sql server 6.5 . how do i append the data to sql server database to the respective tables from the foxpro database.
vineet