Solved

TransferSpreadsheet

Posted on 2004-04-12
3
741 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
default value of combobox 25 70
sIMULTANEOUS USAGE ON NETWORK-ACCESS 2010-2013 7 77
Displaying images within Access Form 6 76
Access 2010: Combo Box Query 5 18
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
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…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

751 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