I created a report using InfoView, and want to export it as Excel, but the Excel file always ends up with an empty row at the bottom. Since I import the data from this excel spreadsheet into Access, the import process fails because the empty row does not meet the constraint requirements.
On the report block/table within InfoView, I unchecked Show Table Footers. In Page Layout/Relative Position, I changed left edge and top edge to 0 (which eliminated the empty row and column at the beginning), and unchecked all of the boxes including Repeat footer on every page.
How do I eliminate the empty row at the bottom?
I also tried exporting the data from InfoView as a text/csv file, but that process only pulls the results of the query, not the report, so any calculated fields are not included in the result colums. If anyone knows a way to force it to include the calculated fields, that would be an acceptable work around.
As an alternative work around, if anyone knows how to supress the error message when I try to import the data with the empty row into Access, that would be acceptable as well. I actually have a table linked to these data outside of Access and then run a query to insert into a table, and it is this insert process that gives me the error message. I have supressed alerts via the Access Options under Advanced, but the message I receive is asking me if I want to continue the insert statement and ignore the empty row, or cancel the insert altogether. I would be fine with ignoring the empty row but I cannot figure out how to automate this.
I am using Excel and Access 2007. I don't know what version of InfoView we are using but when I click on About it says 12.1.0.