hello! i need help in importing sql tables to ms access 2003 using macros. i'm trying to import the tables from a sql server to my Access. i know how to do this using dts but since the sql server i'm using is a third party, i have way to configure a dts. i'm stock with my Access, i tried to use several macros, even combined some to import the tables but cant seem to import. just an idea on what to use will greatly help =) thanks!

Where are the tables stored?

Have you got an ODBC connection?

If the tables you are trying to import are in a remote server, and you are running an ODBC to use your SQL to extract data from this server to populate excel, then you can import and link the tables into Access from your remote server using your ODBC connection.

In your database window goto the table tab and create a new table, choose link from the menu, on the link dialog box, change the Access paremeter to ODBC and then go from there.

Hope this helps.