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

E

Eric

Does anyone know how to retrieve the value within the table from Access into
Excel?
Thank you in advance
Eric
 
K

Klatuu

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.
 
K

Klatuu

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.
 
E

Eric

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