R
RBCC
How do I take data from a access database and put it into a excel
spreadsheet? John
spreadsheet? John
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Klatuu
See Help for information on TransferSpreadsheet
C
Chegu Tom
Also with a table or query open you can to to 'Tools-Office Links-Analyze
witth Excel' to load the current recordset into a spreadsheet
witth Excel' to load the current recordset into a spreadsheet
A
Arvin Meyer [MVP]
RBCC said:How do I take data from a access database and put it into a excel
spreadsheet? John
In addition to the TransferSpreadsheet method, you can also use the OutputTo
method. The difference is mainly in how you need to deal with the data. With
TransferSpreadsheet, you can out put the data to a specific range, but
you'll need to Shell Excel to open it to that workbook. With OutputTo,
Excel's opening can be controlled from within the function.