Importing tables using a macro

[PowerPoint Jedi]

First off thanks for taking a look at this. I am using Access 2003.

Here is my problem. My company has a lot of data I need to in an database
on an SQL server (.ADP extension). I am haivng a lot of issues trying to
work with this database. What I would like to do is link the tables to a new
local database and work from there, unfortunatly it won't let me link the
tables, I can only import them. So here is my question:

Can you write a macro to import the tables from an .ADP database to a .Mdb
database? If so how do you do this? This way I can just execute that part
of the macro to update the tables then run the rest of my queries off those
updated tables.

Thanks again