Exporting Multiple Queries to Excel

M

Melissa

I am currently using Access 97 and need to export multiple
queries to an Excel file (Excel 2000). I have tried to
setup a macro to do so, using Transfer Spreadsheet, but
receive fatal errors anytime I try to run it. Is this
because I am exporting to Excel 2000 and not 97 or 5-7?
Is there a way around this?

Any help would greatly be appreciated!

Thanks,
Melissa
 

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

Exporting Multiple Queries from Access into Excel 2
Exporting multiple queries into Excel workbook tabs 10
Exporting pivot tables 2
Can't export to EXCEL file 1
Exporting table containing dates 6
Export to XML - error 31532 0
Exporting Queries to Excel 1
Exporting filtered data to Excel 3

Top