>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.