Importing and replacing tables

[Ian]

I am trying to automate an ODBC import to update tables
using a macro.

If the tables are already in Access it add a "1" to the
end of the table name. Is there any way to have it
replace the previous table?

I have added deleting the tables to the macro but if the
table did not exist in the first place then the entire
macro fails. Is there a way to have a macro continue if
one line doesn't work.

Also is there a way to use a wild character to delete
several tables in database?

 

[Guest]

1.)Is there any way to have it replace the previous
table? NO, not using IMPORT

2.) Is there a way to have a macro continue if one line
doesn't work? In your case, NO

3.) ...is there a way to use a wild character to delete
several tables in database? NO

The only way to achieve what you are trying to achieve is
through code such as VBA. But if you linked these tables
instead Importing them, most of the problems you mentioned
would be solved. Any changes to the ODBC object would be
realized in near real time so there would be no need
to "update" the tables. You do not need to delete
tables. And you would not have a need for wildcard
characters.

Sorry I could not be of more help,
Marty

 

[Joe Fallon]

You can write VBA code to delete the orginal table and re-name the tables
with 1 so they don't have it anymore.
Do you need sample code?

But linking may be a better idea.
In which case you shouldn't need any code.