ODBC Insert into a FoxPro free table in VB.NET

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Attempting to read records from Sql Server and load a FoxPro Free Table. Can not locate the "proper" format for the execute command that will use the sql insert string and actuallyadd records to the free table. Any and all suggetsions are welcomed.
 
In news: (e-mail address removed),
Ben Harris said:
Attempting to read records from Sql Server and load a FoxPro Free
Table. Can not locate the "proper" format for the execute command
that will use the sql insert string and actuallyadd records to the
free table. Any and all suggetsions are welcomed.
Click to expand...

Hi Ben,

It would be helpful to see what connection string and code you have so far.
It would also be helpful to know what your data is like - which data types
and whether you're working with null values.

Also, did you know that you can use the FoxPro OLE DB data provider as an
alternative to ODBC? It's available from
http://msdn.microsoft.com/vfoxpro/downloads/updates/default.aspx.
 
Back
Top