VBA code that will link tables

  • Thread starter Thread starter lw
  • Start date Start date
L

lw

I am trying to write a code in the module that will run a
link macro and get a table one at a time from access 97,
delete that table and go get another table so that several
tables from access 97 will be put into one table in access
2000. Can such a code be written?

Help!
LW
 
get a table one at a time from access 97,
delete that table and go get another table
Click to expand...

Do While GetNames(strNewTable, strOtherTable, strOtherDatabase)

strSQL = "SELECT * INTO " & strNewTable & vbNewLine & _
"FROM " & strOtherTable & vbNewLine & _
"IN " & strOtherDatabase

db.Execute strSQL, dbFailOnError

Loop


Not tested, of course, but should be quite close. Wouldn't it be easier to
back up the database and simply use Access to convert it, though?

HTH


Tim F
 
Back
Top