Hi,

Everytime I import an excel sheet to a new table in access, I keep on having several blank (empty) records or rows. I did my homework and it seemed like those blank rows got imported to access coz access recognized it as rows with values...

this caused me a problem and now i would like to create a code that would erase all of those blank records in the access table after i imported them.

here's the code that i have at the moment. Can anyone help me modify this? 

Please Login or Register  to view this content.