Importing data from access to excel to a specific columns
 

Hi,
Does anyone know of a code to export data from an access table to an existing
excel sheet. The excel sheet already has columns names. I searched the site
but I could find an answer. Thanks in advance.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...links/200809/1

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