LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Getting external data from Access 2007 using msquery terry???????? Excel Discussion (Misc queries) 0 June 19th 08 05:16 PM
viewing newly created access queries in excel via msquery CWCPGCFin Excel Discussion (Misc queries) 0 September 29th 06 10:32 AM
Refresh MSQuery w/ Access datasource issue Chris B Excel Discussion (Misc queries) 1 June 29th 06 08:46 PM
MSQUERY...My Exact question (Excel 2000) SEAN DI''''ANNO New Users to Excel 1 April 7th 06 03:35 PM
Modifying an Access record in Excel John Moll Excel Programming 1 August 1st 03 05:27 PM


All times are GMT +1. The time now is 01:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"