Error exporting data from access 2007 to excel 2007

J

Javier71

I have developed an application in Access 2003 and within this application I
created a Macro that exports some records to excel, it works perfect on
Access 2003 but when I run the application on Access 2007, the Macro doesn't
work. Even if I use the toolbar button provided by Access 2007 to export to
Excel 2007 it doesn't work either. Is this a problem with Office 2007 ?? Can
anybody help me? This is urgent!
 
A

Allen Browne

Do any of your code/macros run? If not, it may be a matter of trusting the
folder where your database is.

Go to:
* Office Button (top left)
* Access Options (bottom of dialog)
* Trust Center (left)
* Trust Center Settings (button)
* Trusted Locations (left)
* Add new location (button)

If that is not the issue, this Jan 28 hotfix does address an export failure
with the XLS format:
http://support.microsoft.com/kb/943249
 

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 a table from Access 2003 to Excel 2007 1
Exporting Query from Access 2007 to Excel 2007 4
Convert Access 2007 to 2003 errors 1
replace Access 2007 with 2003 1
2007 Data Export Limit 2
Access 2003 db's & problems exporting query to Excel 1
How can I make Access 2003 work with excel 2007 files? 4
Error 429 on opening Outlook 2007 from Access 2003 1

Top