Problems Exporting a table

M

merry_fay

Hi,

I'm trying to export a table from my database into an excel spreadsheet, but
it keeps saying it can't find the object 'ExportData'. It definitely exists &
the rest of my code is quite happy to use it, so I'm really confused as to
what I'm doing wrong!

This is the code:

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "ExportData",
"H:\Miranda\Fred.xls"

Any ideas/suggestions?

Thanks
merry_fay
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export Access pivot table to Excel 0
Run time error 2391 when exporting Access table using VBA in Excel 1
Problems Exporting from Access 3
Problem exporting multiple tables into different worksheets in oneworkbook 3
expected format 2
Exporting to an excel template file 0
Access Export of data to Excel using VBA - data looks awful 4
Excel export problem 2

Top