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