export report to Excel results in 2 rows of column headers
I can't do this with exporting a query, so I tried using a report. If I make text boxes for the desired duplicate column headings, it works just fine. The problem is that on row 2 of the exported data, the actual column headings from the query are also exported. Can this be avoided?
Sample of exported data:
Ded % DedAmt | DedAmt
Ded | DedAmt | DedAmt2
Thank you for taking the time to report an issue.
What's wrong... Please write below.
This import file can contain but not have to couple of columns. Also it might contain Headers or not and lastly it might have some empty rows between each serial.
This data is then processed and then the user selects where to save the exported file with a lot of information in it.
Now I have solved the issue of prompting a user to choose which column the data starts at (ex. A1 or B1 etc.)
Now I have two questions that I need help with and I tried searching online but had no luck.
During the wizard stage I would like to include a check mark that would be IF its checked then it will know that this imported file has headers and it will start at A2 instead of A1!
My second question is about the blank rows, when I import the excel file if there are empty rows between filled in rows is there a way to skip them and then on the export sheet just showthe rows that were there on the first excel sheet?
Is it also possible to modiy the code as well, such that when the data is exported to excel that all the rows in Excel are the same height
I have a report that contains column totals. I have a macro setup to export this to excel. I realize the totals will not be exported because of the way I am using the unbound text boxes to calcuate them in the report footer.
The strange thing is that when I manually total up the fields in excel they do not match my report totals. I have visually compared the report to the excel file and every record has been exported. This seems impossible
I have a Button "Export to Excel" and when I filter results and hit this button, it exports my filered results to excel. This works fantastic on the first and the second tab. But on the third tab, no matter what my filtered results are, it only seems to export the column headings and nothing else. My VBA code is as follows. Can you please tell me what I'm doing wrong and suggest a fix please
2. I have footer sums in the Report Footer. Can I display the footer sums with out displaying the Column Headers in the Page Header Section.
What's the easiest way to accomplish this? Is it possible to put a command button on the Report itself that, when generated, allows me to export the results to Excel?
The report opens fine in Access [takes about a second to open] - and I was able to export it as a pdf - [686 pages].
When I try to export it as an Excel Spreadsheet - it scrolls through about 600 page numbers [in the export progress dialog box] and then displays an 'Overflow' dialog box. The spreadsheet is not created.
In that data, if the values in column AG are greater than 2, I would like to export columns B, C, I, J, Q, R, T, AG, and AH - BQ to an Access Database titled WOWData.
In order to have the column headers print on every down page, you place them in the "Page Header" section, that I know.
My question is, if there a way to make the first column repeat on every accross page in the same fashion?
I guess what I'm looking is for a similar function that Excel has to repeat Row 1 / Column A on every page. I know I can export to Excel, but the client doesn't have Office, and they will use Access Run time.
If I can incorporate Excel spreadsheet with my Access Application using only Access Run Time, that would be great, if not, Is there another way. manually or with VBA