Import Acces data into Excel using MSQUERY question

  • Thread starter Thread starter Harry
  • Start date Start date
H

Harry

Quick question 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 a record
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?

Thanks

Harry
 
Gary Brown said:
Don't crosspost. It wastes everyone's time.

OP multiposted. Failure to use correct USENET terminology wastes everyone's
time and demonstrates the vast frontiers of YOUR ignorance.
 
Back
Top