Solved

TransferSpreadsheet

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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Running Access application from Task Scheduler 6 32
Format vertical text in Access 2016 3 31
MS Access to SQL Conversion - Bit and Yes/No Datatypes 12 46
Sub Reports 8 21
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

911 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