Insert the records into ODBC linked tables

[accessman2]

Hi,

I have a lot data to append to ODBC linked table in MS Access. I want to know that which way is faster to append the records.

if I append the data into ODBC linked table,
1) create the one query (append) to insert the records into ODBC linked table
2) use the VBA code (DAO/ADO) to insert the records into ODBC linked table

which way is rather faster?

 

[boblarson]

If I've picked up on anything that posters have posted here, I believe that #1 would be your way to go because:

1. The query is already compiled and Jet knows what it is going to do with it. The other would still have to compile.

2. #1 still uses DAO (what Jet uses)

Now, that may be a simplistic answer and The_Doc_Man, or someone else may correct me or explain further.