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: 10
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:

More topics

 

Importing Excel into Access with few requirements

Preview
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?
 

Importing Excel into Access with few requirements

Preview
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

Preview
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

Preview
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.

I've tried printing to word, same problem as excel. Tried printing a pdf and it looks exactly the same but I can't edit it to add the extra blank rows.
 

Report export to Excel with format

Preview
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.
 

Export to Excel Issue

Preview
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
 

Report Export to Excel

Preview
access,
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
 

Report Headers/Design

Preview
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.
 

Exporting Report to Excel via Command Button

Preview
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.

Preview
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.