Pulling Access data into Excel
 

Hello

Two quick questions please

I'm doing a database query from Excel 2003 in Access. I go:

Data/Import External Data/New Database Query/

and then I progess through the wizard, selecting my Access file, selecting the
matching criteria and then selecting the cell in the Excel sheet to import to.

It grabs the right records from Access, but it imports the data from the Access
record and displays it across a row, and I'd like to go down a column, cause
that's where the proper target fields are for the fields from Access.

Why does it seem I can only import data across a row using MSQUERY? I'm having
to put those into a dummy sheet across a row, and then find a way to copy the
contents into the proper sheet in the proper cells.

Second question, is there an easier way. It is awkward to walk through the
keystokes to do the MSQUERY, selecting the options etc. each time.

Thanks

Harry

Pulling Access data into Excel
 

You should only have to do it once. Then just refresh.

It doesn't do what you want because the people who wrote the code didn't
provide that functionality.

--
Regards,
Tom Ogilvy

"Harry" wrote in message
.. .
Hello

Two quick questions please

I'm doing a database query from Excel 2003 in Access. I go:

Data/Import External Data/New Database Query/

and then I progess through the wizard, selecting my Access file, selecting
the
matching criteria and then selecting the cell in the Excel sheet to import
to.

It grabs the right records from Access, but it imports the data from the
Access
record and displays it across a row, and I'd like to go down a column,
cause
that's where the proper target fields are for the fields from Access.

Why does it seem I can only import data across a row using MSQUERY? I'm
having
to put those into a dummy sheet across a row, and then find a way to copy
the
contents into the proper sheet in the proper cells.

Second question, is there an easier way. It is awkward to walk through
the
keystokes to do the MSQUERY, selecting the options etc. each time.

Thanks

Harry