Access 2003 doCmd.Transfer Spreadsheet

Topic

New Reply

Hi I am having difficulty exporting a table called Tbl_Data_Gaps into a folder as an Excel 2003 file to J:Data AnalysisGap using an on-click event and the DoCmd.TransferSpreadsheet method – can anyone help? Seems to only offer an import and doesn’t like the way I’m defining the route to place the file (I’ve tried “”, [] and () to contain the file name). Can anyone help??

Much obliged.

blitzy

Reply | Quote

Replies

Blitzy,

Could you please post the code for the On-Click Event? :cheers:

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

Blitzy,

Could you please post the code for the On-Click Event? :cheers:

HI AS REQUESTED THANKS!

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, Tbl_Data_Gaps, [J:Data AnalysisGap.xls], True

Reply | Quote

Hi as per my first email, have already tried in quotations… no worries will keep trying. thanks.

Reply | Quote

Blitzy,

Try: [noparse]DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, “Tbl_Data_Gaps”, “J:Data AnalysisGap.xls”, True [/noparse]

Here a link to the MSDN Help page for TransferSpreadsheet. :cheers:

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

Blitzy,

I just ran a test using Access 2003 using this command:
[noparse]docmd.TransferSpreadsheet acExport,acSpreadsheetTypeExcel8, “Contracts”,”G:BEKDocsExcelTestExportTest.xls”[/noparse]
and it worked for me. Please note the Table name {Contracts} is in quotes. :cheers:

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote