Exporting VFP Tables to SQL Server 2005
When Microsoft still supports VFPODBC, we can do that by setting up a data source pointing to VFP tables and import them to a MS Access Database.
But according to MS, they no longer support the VFPODBC and they recommend the use of Visual Foxpro OLE DB driver instead.
Too bad; but anyway, we can still do something about this. I'll demonstrate a similar technique that does the same. Without VFPODBC, we will rely on Access' built-in dBASE importing option. The downside though is that it will only let us import one VFP table to MS Access Database at a time.
If you're in for some boring software stuff, please click here to read the rest of the article