Converting Access to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I take data from a access database and put it into a excel
spreadsheet? John
 
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
 
RBCC said:
How do I take data from a access database and put it into a excel
spreadsheet? John
Click to expand...

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Question about Access 3
Alt codes 4
Linked Tables - Do I Need DNS on end users PC? 1
Microsoft Works to Microsoft Office 6
Excel Access - importing an excel spreadsheet 0
Opening excel 2010 spreadsheet from Access 4
Excel How to Fix Damaged Excel File That Won't Open? 3

Back
Top