I have a database of customers on my web server. I can connect to it with Access and view all the customers (about 75,000). I would like to download this to a LOCAL database with Access. The purpose is to produce a mass mailing.
WHAT I NEED TO ACCOMPLISH:
1) I would like to be able to export all the data to a new table that is stored LOCALLY on my computer. I can see how to easily export to Excel, but when I try to export to Access, all it does is sets up a new linked ODBC table. I'm sure there is something very simple to do this, but I'm not seeing it.
2) I would like to do the same with with a query that displays only the fields that I need. This is another option. I already have the query set up. But I can't figure out the export.
I am using Access 2007.
Thanks for your help.