VBA code that will link tables

[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

 

[losmac]

Why are You trying to put data from tables into one?
Have You relation between data?

 

[Tim Ferguson]

get a table one at a time from access 97,
delete that table and go get another table

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