Updating an Excel worksheet with an access database

  • Thread starter Thread starter woknick
  • Start date Start date
W

woknick

Is there a way to take an Access database and export records into a
excel spreadsheet..

Thanks in advanc
 
You can either Export from Access to Excel or Import from Access to Excel.

With Access open File>Export>File Type>MS Excel.

Select all records or use query results and "Export All"

OR

With Excel open go to Data>Import Data and follow your nose.

Gord Dibben Excel MVP
 
If you do not have Access loaded on the machine you are trying to do
this on have a look at www.waa-inc.com/accex, it is a small Excel
add-in to import tables and Queries into Excel worksheets without
having Access.

Regards,

Mike.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Data imported into Excel from Access 1
Data imported into Access from Access 2
Link, drop link, relink 2
Counting multiple memberships 1
Using ADODB Efficiently 1
Excel Spreadsheet display with autorefresh 1
Passing data to an event handler 3

Back
Top