Importing data from access to excel to a specific columns
Do it as a query from Excel.
Data Import External Data New Database Query
(or similar - varies between Excel versions).
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
|