Import Acces data into Excel using MSQUERY question

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
 
H

Harlan Grove

Gary Brown said:
Don't crosspost. It wastes everyone's time.
Click to expand...

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

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

Similar Threads

Importing Access record into Excel using MSQUERY question 3
Pulling Access data into Excel 6
Excel Data Querry using criteria from Cell 5
identify data source 6
Import data from Access to Excel containing VB code 3
Import Data From Access to Excel 2
MSQuery does not see the tables in an excel workbook, help. 3
Excel 2010 Table not showing in Access 2010 Import List 0

Top