Query Data in Excel S/S from Access DB

[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

 

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

 

[AG]

Hi Joel,

Thanks. I will try that and let you know if it works.

Regards,
AG