| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.links
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reserved Error (|); while importing data to Excel from MS Access | Links and Linking in Excel | |||
| Importing data from Excel to Access | Excel Discussion (Misc queries) | |||
| Importing specific data into an Excel workbook | Excel Worksheet Functions | |||
| Importing Data from Access into Excel | Excel Discussion (Misc queries) | |||
| Importing data from Access into Excel: prob w/ cutting off fields | Excel Worksheet Functions | |||
Linear Mode
