![]() |
invalid sheet name problems
I am using crystal reports to export data to an excel spreadsheet. in office
2000 the spread sheets open fine, but in office 2003 or office xp i get an error saying that office was able to open the file but had to rename an invalid worksheet. The sheet is originally names Sheet1. How can i fix this issue? This is an issue because I am currently writing a script that will take multiple excel spreadsheets and import them into a sql server database. when i go to open the excel spread sheets via the script i get an error saying that an error occured, but the engine running the script does not know what error. I think this is the error because if i rename the sheets and try the script again, it works. thanks for any and all help! Ben |
All times are GMT +1. The time now is 11:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com