Solved

TransferSpreadsheet

Posted on 2004-04-12
3
705 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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

803 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