Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

TransferSpreadsheet

Posted on 2004-04-12
3
Medium Priority
?
780 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 150 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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
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…
Suggested Courses

926 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