Blank Recoreds in Access

[JDelamora]

Hello All!!

I have recently encountered some issues with my database. When I load data from an .xlsm file to my front end table, I get additional records with no data only the ID. The data I loaded comes in fine, however I get many of these records with no data only the ID. Does any one know what is going on. This only happens in one of my tables. Need to be rescued.

[JoeM]

It sounds like you have a bunch of blank Excel rows that are getting imported. If you go to the Excel sheet in question, and click CTRL-END, what row does it go down to? If it selects a row that is beyond the end of your data, it is importing these rows. This can happen if data was cleared, or extra rows have formulas or have been formatted.

There are a few different ways around this:
- Delete the extra rows in Excel before importing.
- Use named ranges in Excel to only select the data rows, then import into Access using the named range instead of the sheet name
- Make one of Access fields required. When it tries to import a blank record, that whole record will fail and not be imported into Access.
- Create a Delete Query to "clean-up" your data by deleting the blank rows after an import.

Hopefully, one of those ideas will work for you.

[JDelamora]

JoeM,

Thanks a lot, the solved my problems..