Import from Excel creates empty records

[Sarge, USMC]

I take raw data downloaded from our website into an excel spreadsheet and import into an access table.
When I do that, empty records are created in the table, and I don't know why.

Also, one of my tables is returning the following when I import from excel:



It only happens when importing to that specific table, and again, I don't know why. Clicking "Yes" does import the data tho.

Any assistance would be greatly appreciated.

TY.



Semper Fi

[ranman256]

sometimes excel has 'nothing' but access sees it as something.
(like pressing the delete key to remove excel data, theres no data there, but excel will still show records)

during import, filter out the blanks
[field] not null
or
[field]<> ""

[Sarge, USMC]

I'm sorry...I'm unsure of what you're telling me to do. Specifically what's happening is a bunch of empty records are being added to the table that appear above the existing records in the table....so I have to delete all the empty records every time I import.

If I look at the page break preview of the excel data, there are no "empty" rows. So I'm not sure why access is seeing "empty" data and creating "empty" records in the table.

It's not XP.....its Win10

[ranman256]

build an append query (import) to ignore the empty records
where [field]<>""

[John_G]

...a bunch of empty records are being added to the table that appear above the existing records in the table.

That does not mean that they were at the top of the spreadsheet. In many cases, where you see them when you open the Access table is governed more by how the Access table data is sorted than it is by where the blank rows were in Excel.