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: 14
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?
 

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.
 

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.
 

CSV Opens Fine In Excel Not in Access

CSV Opens Fine In Excel Not in Access Icon
I have a very large CSV file, around 2.5million rows. The file is delimited by a comma and opens (well the first 1,064,000 rows) successfully in Excel. However in Access, where I want to aggregate this down, it is not.

For example in column F is a text string, "Where," In Excel, that entire string is in column F, however in Access, "Where" is in column F," is in column G and therefore everything else is pushed over by one column.

I can't use excel to "replace all" comma's since I can't see the whole file (again only the first million lines, I'm in excel 2007). I've tried a few dozen different input methods from Access but I'm not getting the best results either.
 

Which Export to Excel Method is Simpler to Implement?

Which Export to Excel Method is Simpler to Implement? Icon
I am creating an Access database that will be created from several Excel workbooks. The final results will need to be in both an Access report, and an Excel worksheet. The database will beonline,

I can think of 2 methods in which this could work:

1) I link the Excel workbooks to the Access database. I take the input values and make a form in Access to be filled out. The form is filled out and spits the values back to Excel. Excel performs its calculated formulas. Access then grabs the resulting values and fills out a report with them.

However, I am unsure if this is possible in terms of returning values back to Excel, then grabbing the results?

2) I recreate the work of the Excel workbooks in an Access database. I then use VBA to export the results to an Excel template.

I am not sure how to do this, but I have found this page: [LINK] Unfortunately, whenever I run the MDB it gives me an error.

I would think the 1st method would be much easier if possible. I will be using Access 2007.
 

Export Formatted Report from Access to Excel

Export Formatted Report from Access to Excel Icon
Does anyone know a way to export an Access report with group levels to Excel and keep the layout and formatting of the report in Excel? Whenever I export my report to Excel it screws up the format.
 

Exporting a report into exell

Exporting a report into exell Icon
I am trying to export a report into excel but when I do the order of the columns change, doe anyone know how to export the file maintaining the column order as in the report?
 

Identifying Differences In Tables

Identifying Differences In Tables Icon
I am struggling bad. Very new to using Access although I have taken 3 classes but still not getting it or I'm always trying to create solutions above my level. Here is my problem,

I run a daily export report out of SAP into Excel. This report has the same number of columns and the columns are identical, however, the data in the columns DOES not have a unique identifier. I need to compare the data and identify all changes between the 2 tables.

Typically, the changes will be: (Excel Spreadsheets Comparison) 1) Rows will be added somewhere, not necessarily at the top
2) Data within the rows can change

I am mostly concerned with data changing in (2) columns of the (7), typically, the changes will be:
1) The cell will change from having data (currency) in it to having no data OR the data will change I.e. 1,000 to 2,000.
2) In my second column, data (number) changes.