>Hi
>
>Does anyone know how to insert data into a dBase table using VBA?
>
>Thanks
>Nelly
If you use DAO, then just use IN clause to specify the table you use:
Here is an exert from MS Access Help file:
----------------------------------------------------------------
You can use IN to connect to only one external database at a time.
In some cases, the path argument refers to the directory containing the database files. For example, when working with dBASE, Microsoft FoxPro®, or Paradox database tables, the path argument specifies the directory containing .dbf or .db files. The table file name is derived from the destination or tableexpression argument.
To specify a non-Microsoft Jet database, append a semicolon (;) to the name, and enclose it in single (' ') or double (" ") quotation marks. For example, either 'dBASE IV;' or "dBASE IV;" is acceptable.
You can also use the DATABASE reserved word to specify the external database. For example, the following lines specify the same table:
... FROM Table IN "" [dBASE IV; DATABASE=C:\DBASE\DATA\SALES;];
... FROM Table IN "C:\DBASE\DATA\SALES" "dBASE IV;"
----------------------------------------------------------------
Now you know how to construct your SQL statement to work with DBase files.
HTH,
Igor Gelin
Database Developer