H
Harry
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
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