[AccessD] Using 'IN' vs. Using Table Links

Dan Waters dwaters at usinternet.com
Fri Jun 20 10:42:57 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




More information about the AccessD mailing list