Export Query using Access 2007 to Excel 2003 Users

[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 5.0/95 Workbook
(*.xls)." This works fine for me, but doesn't work for my Excel 2003 users.

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

thank you,

 

[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, but doesn't work for my Excel 2003 users.

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

thank you,

 

[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 "Excel 97 - Excel 2003 Workbook (*.xls)". This works fine for me, but doesn't work for my Excel 2003 users.

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

thank you,