Elsie has attended:
Excel Advanced course
Access Intermediate course
Importing excel file
When importing an excel file into access how can I avoid blank cells importing.
RE: Importing excel file
Hi Elsie, thanks for your query. You can't stop blank cells being imported during the importation procedure, I'm afraid. Best practice is to deal with them in Excel first (say, by replacing them with NA) and then import the data. This is all part of the normalisation of data that you should carry out when you move data into your Access database; blank cells can cause errors, particularly if fields in your table have been set to refuse Null values, so "clean" the data before you import it.
Hope this helps,
Anthony
RE: Importing excel file
I only want to import say 25k lines as that is where all the data is but i also get the remaining 40500 of the 65k that excel has. I have had to make a delete query to take out these blank rows.
RE: Importing excel file
Hi Elsie. That sounds a lot like those cells, although looking empty, have some formatting attached to them in Excel so it might be attached to some template you're using. A delete query is a good idea though, try using a macro to attach both the importing process and the delete query together so it boils down to one click.
Anthony
