Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 306
  • Last Modified:

Exporting an ODBC table in MS Access

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.

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.

  • 3
  • 2
1 Solution
I would connect from an empty access db to the ODBC table. You can then import the table, so you should be able to export to excel from there.

Choose the "External data" tab -> Click "More" -> Click ODBC-database.

greghollAuthor Commented:
Thanks for your help. Here are some screen shots for posterity

1: Make a new empty db
2: Under IMPORT, select "MORE" and then "ODBC"
3: Enter ODBC information
greghollAuthor Commented:
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

It may sound dumb--but copy and paste.
Pasting gives you options
optionsThis dialog is from Access 2003, but I doubt 2007 is much different.
Make it a local table.

Is it more complex than this?
Or, you just have never tried to copy and paste a table and seen the dialog?
greghollAuthor Commented:
We're talking 75,000+ records here. Way too much for the clipboard to handle
Your call, of course
Here's 145000 row table of a SSEE 2005 linked backend
 originalGoing in local in 43 seconds
 tempWorks fine.
<We're talking 75,000+ records here. Way too much for the clipboard to handle >

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now