Access counts blank rows in Excel rows as records in linked table

  • Thread starter Thread starter Linkerbink
  • Start date Start date
L

Linkerbink

In trying to link an Excel table to my Access database, it always shows 17
records (rows) even though I may only have to rows of data. I can't seem to
make it just link the number of rows which contain data. How do I do this?
 
ACCESS uses EXCEL's UsedRange property to identify how many rows of data
there are in the EXCEL spreadsheet. It would appear that this property needs
to be "reset" in your EXCEL sheet.

Go to the last cell (bottom and right). Go to the next column (empty), and
delete all columns from there to last column in sheet. Go to next row
(emtpy) and delete all rows from there to last row in sheet. Save the
workbook file, then close it.

Now relink to the sheet. You should see just the number of data rows that
are in the sheet.
 
Back
Top