>hello all:
> I have a little project that I need to update access database from an ascii file. If I use odbc to access the access database could I actually write to the database? thanks
>sherry
Once you have a connection to the ODBC remote source you can use SQLEXEC() to send SQL to the Access database or any other database. Build your inserts from the text file the same way you would in VFP and send the insert via SQLEXEC().
Check SQLCONNECT() SQLSTRINGCONNECT() SQLPREPARE() and SQLEXEC() in help.
Eric Kleeman - EDS Consulting Services
MCP Visual FoxPro
MCSD C#.NET
Hua Hin Thailand
Los Angeles California