Converting Excel File to Access

[Guest]

Hello, I have an Excel file I use to collect data from various other Excel
file. I then convert this Excel file to an Access table and can append it to
an exisiting Access table without any trouble. No error messages. Only the
Excel file will bring into the Access table about 900+ extra blank rows.

I've tried highlighting the rows while in Excel and deleting any information
they might have on them. The same thing will happen, the blank lines appear
in the Access table. I'm sure it's a simple fix, but can anyone guide me in
eliminating the extra blank rows?

Thanks for your help.

 

[George Nicholson]

In Excel, don't "clear" the rows, delete the rows. Then save the file.
"Clearing contents" doesn't reliably reset what Excel thinks is the
range-in-use. Deleting rows (& columns) does.

Also: if you are converting the xl file to a table and then appending that
table to another (i.e., using 2 steps rather than 1), you could modify your
append query to only append records that were not null in a key field(s).
That should filter out empty rows.

HTH,

 

[Guest]

Thanks for your help. The information was helpful. The Excel file still
indicated that the blank rows were still there even after deleting the entire
rows. (By pressing "control end".) However, I found that by changing the
Access table (to be appended to) design parameter "Allow Zero Length" to No
eliminated the blank rows.

I still have an Excel problem about the blank rows, but that's another
discussion group.

Thanks again.