Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import Access 2007 report to Excel
I have a complex report with grouping, sub reports and subtotals that I would
like to export to an Excel Spreadsheet. Access has never been able to export the report to Excel satisfactorily, and I always exported it as a text file and then imported the text file to excel, using the text to columns wizard. I don't mind losing the subtotals, but I want to retain the grouping and columns in the report. Having to go through the import process every time with the wizard is a pain, the columns of the report are standard but the rows vary. I used to be familiar with parsing files to Lotus 123 by inserting a line of characters in the first row that identified characters as text, numeric etc and identified when a new cell was to start. I have never done this in Excel without a wizard, so have no idea what an Excel parse line looks like, if such a creature exists. Ideally I would like a command that runs the report, exports it to a text file and then imports the text file to a spreadsheet. Alternatively if someone could direct me to a numpty guide to importing data to excel without using a wizard that would be nice. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column widths change with each new import from Access 2007 | New Users to Excel | |||
Import data from Access 2007 | Excel Discussion (Misc queries) | |||
Import Access data into Excel 2007 | Excel Discussion (Misc queries) | |||
Import Access query to Excel 2007 | Excel Discussion (Misc queries) |