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

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

Ken Snell

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top