Thanks Arjang. I appreciate yours and everyone's continued efforts to help me solve this. Comments below.
On Tue, Aug 17, 2010 at 11:10 AM, Arjang Assadi <[email protected]>wrote: > Hi David, > > what about exporting into XML , CSV or some other cross compatible format? > As mentioned in my previous post, export to XML works nicely - but when I try to import it to Excel 2007 it takes forever (literally hours) to try to open the spreadsheet. The report has over 100,000 rows. There is no option to export to CSV. I did export to a text file, however that requires the user to manually import to excel using fixed column widths and setting the column widths manually by dragging lines in the import wizard. It's pretty error prone and I certainly wouldn't want that to be the standard practice that the users have to go through each time they want a report in Excel. > Is the real problem is that for a user to be able to view the data > with Excel 2007? > No. The real problem is that users wish to be able to manipulate the data *from the generated Access reports* in Excel. It needs to be Excel 2007 because earlier versions of Excel can't handle the number of rows. > > Or what about Importing into Excel as opposed to Exporting to Excel? : > In Excel 2007 can you goto the Data Tab and select Connections, and > pick up the Access File? using that method instead of exporting to > Excel from Access you be Importing to Excel from Access, as much as I > can't see a difference in the end result I am not fully aware of all > your problem contrsaints. > Again, this would be useful for importing the raw data from Access. What the client needs is to be able to import the generated reports, including calculated fields, totals, formatting, etc. *exactly as they see it on the screen in the reports*. Cheers Dave
