Solved

TransferSpreadsheet

Posted on 2004-04-12
3
673 Views
Last Modified: 2012-06-27
hi

Below is the code ued to export from Access table to Excel. Error occures. "Failure creating file".

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Exll", "D:\BalancePay\test.xls"

I would like to know, how to export tables in different sheets in same workbook.

Help!!!!!

Regards
Citims.
0
Comment
Question by:citims
  • 2
3 Comments
 
LVL 11

Expert Comment

by:mdmackillop
ID: 10804530
Hi citims,
my export routine codes as follows:
DoCmd.TransferSpreadsheet acExport, 8, "Data", "D:\BalancePay\test.xls", False, ""
Also check your spelling of Excel

Regards
MD
0
 

Author Comment

by:citims
ID: 10804659
Hi MD

Thanks a lot.......................

Regards
Citims
0
 
LVL 11

Accepted Solution

by:
mdmackillop earned 50 total points
ID: 10804952
Hi,
Re the second part of your question, add a sheetname to the foregoing code
DoCmd.TransferSpreadsheet acExport, 8, "Data", "D:\BalancePay\Test.xls", False, "Sheet90"
MD
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now