Output from Access 97 to Excel

[DavidCroft]

I'm using the OutputTo method in MS Access 97 to output a report to an Excel workbook. The workbook created opens fine in Excel 2000 but if I try to open it in Excel 2002 I get an Excel dialog saying errors detected "renamed invalid sheet name". I have a user with Access 97 and Excel 2002 on her machine and need to get them to work together. Incidentally there is a Microsoft KB article that indicates that the format output by Access 97 is Excel 5.0/95 (not Excel 97 as the Help says and you might expect). I guess there is some incompatability between the Excel 5.0/95 format and Excel 2002?
Thanks in advance for any help,
David

 

[NateO]

Why not just export a query or table?

DoCmd.TransferSpreadsheet acExport ?

http://www.mrexcel.com/board2/viewtopic.php?t=46578&start=10

You can then use the same path (set up a string constant) to open the file from Access (early or late bound) and clean it up programmatically from Access with a hidden instance of Excel. I've found this to be relatively quick even with a lengthy procedure...

Either that or use MS query or a Pivot Query or something to pull Access data from Excel... There are definitely options for pulling and pushing between Excel and Access. Really sophisticated queries probably ought to processed in Access and pushed to Excel...