View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Harry[_7_] Harry[_7_] is offline
external usenet poster
 
Posts: 9
Default Importing Access record into Excel using MSQUERY question

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