Query Data in Excel S/S from Access DB

A

AG

Hi,

Can someone help me on how can I pull data from access database into
excel spreadsheets. My access database house the raw data, which is
used to create reports in excel. I need a way to pull the data from
access db into excel s/s based on the criteria. The criteria is going
to be based on the fields that are needed and we need to extract those
fields for the specified items. I don't know how can I do this using a
macro. Can someone please help me? Thank you.

Regards,
- AG
 
J

Joel

I would start by trying a query first. You can always use a macro recorder
while performing the query so you can modify it later.

From the Data menu
Import External Data - Import External datta - New Database Query.

The command text portion of the query is the SQL statements.
 

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

Top