Export Query using Access 2007 to Excel 2003 Users

G

gmead7

I have (Office) Access 2007, my users have (Office) Excel 2003.

Previously, I was able to set up a macro to send a query out to Excel by
selecting Output to "MicrosoftExcelBiff8(*.xls)". In Access 2007, I don't
have the option to select "MicrosoftExcelBiff8(*.xls)" as an Output type.
Rather, the choice is for Output format of "Microsoft Excel 97-2003
Workbook (*.xls)." This works fine for me, having Access 2007, but doesn't
work for my Excel 2003 users.

I'm looking for an easy, straightforward work around.

thank you,
 

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

Top