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.
 
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...
 
Back
Top