Dan Waters
dwaters at usinternet.com
Fri Jun 20 13:26:07 CDT 2008
When inserting data into a table I can do this if I have a table link to another database file: stg = "INSERT INTO tblSomeTable (Field1, Field2, Field3)" _ & " VALUES '" & txtField1 & "', '" & txtField2 & "', '" & txtField3 & "')" DoCmd.RunSQL stg Or I can do this without a table link to another database file: stg = "INSERT INTO tblSomeTable (Field1, Field2, Field3) IN '" & stgMDBPath & "'" _ & " VALUES '" & txtField1 & "', '" & txtField2 & "', '" & txtField3 & "')" DoCmd.RunSQL stg Does anyone know if one way is faster than another? I need to do this repeatedly. Thanks! Dan