Export Query using Access 2007 to Excel 2003 Users

  • Thread starter Thread starter gmead7
  • Start date Start date
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 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 said:
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,
Click to expand...
 
gmead7 said:
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,
Click to expand...
 
Back
Top