Importing Access record 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
 
Ad

Advertisements

T

Tom Ogilvy

import it to a dummy sheet, then use formulas to refer to the result.

Why does access show fields across the top? MSquery?
 
H

Harry

Thanks Tom. I've got a problem with that, but I'm really green at Excel
automation. If I create a dummy sheet within my worksheet, and then do a
formula in each of the target cells:

value=sheetname(cell_value)

then it will be impossible for me to change any of the 17 fields in the target
cells if they need modification, since it is only a formula it's displaying.

Harry
 
Ad

Advertisements

T

Tom Ogilvy

Were you planning on updating the data in Access? To the best of my
knowlege, this approach is one way.
 

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

Top