rename invalid sheet name from access 97 report to Excel 2002

  • Thread starter Thread starter dls99
  • Start date Start date
D

dls99

When I export a file from Access 97, my only choice is to
export to Excel 97. I then open that file, with excel
2002, and I get an error message the the sheet had an
invalid name and had to be renamed, but there is no
apparent difference in the the name "Sheet1" in excel 97
or "sheet1" in Excel 2002.

(I can find NO conversion sw, or find any way to "add to"
my file types list. I am forced to use Access 97 with the
office 2002 suite for now)

Any Ideas on what is causing this?
DLS 99
 
Can you open the file in xl97 to see what the sheet name is/was?

Or do you know what the sheet name would have been.

On the other hand, if xl2002 didn't like the name and changed it to something it
found ok, why bother worrying?

Just curious.
 
Back
Top