Topics Search

export report to Excel results in 2 rows of column headers

export report to Excel results in 2 rows of column headers
Views: 12
Here's my issue. I have to export data to excel for uploading to a vendor's system. The vendor required that several of the columns have IDENTICAL headings, and one of the column headings has to contain a % symbol at the end.

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
Sponsored Links:

Similar posts...


Importing Excel into Access with few requirements

Importing Excel into Access with few requirements Icon
I'm fairly familiar with access as I use it as a front end to my database. I have created a wizard which goes through couple steps from selecting Import file which is excel with maybe couple of rows with serial numbers in it.

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!

Second Question:

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?

Exporting ADO Recordset to Excel

Exporting ADO Recordset to Excel Icon
I have the code below that works to export data in an ADO Recordset to an Excel file, however, I would like it to be modifiied such that the Column names/headers are also included when I export the data from access to the excel file.

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

Report export to Excel with format

Report export to Excel with format Icon
I have a beautiful report and when printed straight from access it has nice gridlines and even gridlines null fields (which I want). However when I export to excel all the fancy gridlines and bold fonts are lost. Is there a way I can get it to export to excel what I can print in access? I would like to be able to export to excel to add some extra rows before printing but not have to do all the formatting.

Report Headers/Design

Report Headers/Design Icon
1. I have a report with 23 columns. The columns contains 3 or 4 digit numbers. The Column Headers (in Page Header Sec) are wider than the numeric data in the columns. How can I display the column headers in a way to be long enough to be descriptive yet not waste space on the report - so ideally it may fit on One page.

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.

Report Export to Excel

Report Export to Excel Icon
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

Export to Excel Issue

Export to Excel Issue Icon
I have a "Search Engine" on my DB which is mad up of 3 tabs. In the form you can filter results and in each subform, various information is displayed. This works fine.

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

Exporting Report to Excel via Command Button

Exporting Report to Excel via Command Button Icon
I have several reports that I'm able to generate within my database, but as I run these report I need to be able to export the results of the reports to Excel so I can in turn provide thesereports to my internal business customers.

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?

Overflow message when trying to export Report to Excel.

Overflow message when trying to export Report to Excel. Icon
I have a report based on a table that has six fields and just over 32k rows of data in it.
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.

Export Specifics from Excel to Access

Export Specifics from Excel to Access Icon
I would like to set up a module in Excel that will export certain columns and rows to Access, if they meet a certain criteria. In my spreadsheet, my column headings are in row 30 and my actual data starts in row 33.

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.

Repeating a Column

Repeating a Column Icon
I'm designing a columnar report that will span to many pages down and accross.

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