Transfer data from access to different excel worksheets

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

Guest

Hello everybody,

How can I transfer data from and Access database to an Excel workbook, in
different worksheets? Shall I first create an "empty" workbook with those
worksheets and then how? (i have already created the required queries)

Please help.

George
 
If you use DoCmd.TransferSpreadsheet, you can pass the name of the
worksheet as the Range argument (even though Help suggests you can't).

So just use successive calls to TransferSpreadsheet to export each
query, passing the same filename but a different Range name each time.
 
Thanks very much John. It works just fine.

Ο χÏήστης "John Nurick" έγγÏαψε:
 
George,

Building on John's reply, just make sure you don't use any "funny"
characters in the sheet names; Excel may support them, but they do not
transfer across, so confine yourself to alpha, numbers and underscores.

HTH,
Nikos
 
Thank you Nikos

George (Cyprus)

Ο χÏήστης "Nikos Yannacopoulos" έγγÏαψε:
 
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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Data transfer from screen outside 3
VBA - retrieve data on last create named range from previous inserted named range 0
Transfer data from any mdb file to sql server? 1
Excel Multiple Worksheets - TransferSpreadsheet VBA 0
save excel template to another excel workbook from within Access 1

Back
Top