impoting tables frm ODBC

[amadkow]

I am pretty new to Access so I am sorry if I get any terms wrong and what not.

My problem is that I need to set up a macro or something to automaticly delete two tables and then import 2 tables from an ODBC database. I need to make this as userfriendly as possible. I can't get it to delete the tables but I have no idea how to get it to import the new tables.

 

[jomusichn]

Use a make table query.

Link the tables that you want imported.
ie: "tblODBC"
use a a make table query to copy the imported data to a table.
ie: (tblODBCImported).


I do this often and I set the query to run once a day.

John

 

[amadkow]

OK I will give that a shot thanks.

 

[amadkow]

how do I make a make table query?

 

[reclusivemonkey]

In the query design view, click "Query" on the file menu and then choose "Make-Table Query".

 

[FLabrecque]

I have the exact same question.. so instead of making a new thread, I'll post it here.

Is Make-Table Query available in MS-Access 2000? It doesn't appear in the FILE MENU of my query (or table, I tried both). And... yes, I did click on the double arrows to see all the choices available.

If it's not possible with my version of Access, how should I proceed?

Thanks!