How are you exporting. You can select which version of Excel you wish to export to. I run 2007 and export to earlier versions all the time.
Here is some code that you can attach to a command button that will export a query to earlier excel versions
Code:
Private ExportQuery_Click()
On Error GoTo Err_ExportQuery_Click
Dim reportName As String
Dim theFilePath As String
reportName = "MonthlyActivity"
theFilePath = Type where you want your file exported to here.
theFilePath = theFilePath & reportName & "_" & Format(Date, "yyyy-mm-dd") & ".xls"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, reportName, theFilePath, True
MsgBox "Your report has been exported as and Excel Spreadsheet"
Exit_ExportQuery_Click:
Exit Sub
Err_ExportQuery_Click:
MsgBox Err.Description
Resume Exit_ExportQuery_Click
End Sub
The "acSpreadsheetTypeExcel9" tells it to export as version 97-2003. Because you are using 2010, it probably says 14 where my code says 9. You will have to change the name of your query from my "Monthly Activity" to the name of your query.
Question: If you client is running 2003 and you are in 2010, have you made allowances for the Access db to run in 2003?
Good Luck.
Alan