Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Must open, 'save as' excel files from Crystal 9 Ent for Access to read
The issue is why can't a Microsoft product - Access - open a file cleanly from another Microsoft product. I'm wondering if there is something I don't know about Crystal Enterprise where the report is generated from that would allow the use of worksheets 2 and 3 without having to open the file...- blkhills
- Post #3
- Forum: Business Objects:Crystal Enterprise
-
Must open, 'save as' excel files from Crystal 9 Ent for Access to read
Several reports are scheduled in Crystal Enterprise 9 to create to excel files overnight. A batch job runs to read these excel spreadsheets in to MS Access data warehouse. The data warehouse will only successfully open and import the data in the spreadsheets that have just 1 worksheet. Any...- blkhills
- Thread
- Replies: 4
- Forum: Business Objects:Crystal Enterprise
