How to retrieve the value within the table from Access into Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know how to retrieve the value within the table from Access into
Excel?
Thank you in advance
Eric
 
Are you asking how to get data that is in an Access database table into an
Excel Spreadsheet?

If so, there are a couple of ways. The easiest would be to use MSQuery in
your spreadsheet. The other requires some VBA coding.
 
Do you have any step by step example on how to use MSQuery?
Thank you
Eric
 
From you Excel menu, select Data, Import External Data, and New Database
Query. You will be presented with a wizard that will walk you through select
your database, tables and querys, fields, etc. Not that much different that
the Acces query builder.
 
Thank you very much
Eric

Klatuu said:
From you Excel menu, select Data, Import External Data, and New Database
Query. You will be presented with a wizard that will walk you through select
your database, tables and querys, fields, etc. Not that much different that
the Acces query builder.
Click to expand...
 
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

VBA - retrieve data on last create named range from previous inserted named range 0
Access #Error & Excel Pivot 0
Retrieve data from Access database and fill data in form 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
How to export table from outlook into ms access table? 0
How to retrieve the value? 3
Access to Excel filtered 3
How to retrieve value from specific cell value? 1

Back
Top