Hi All,
Hope you are good. Please note that I have a question regarding importing data from excel to access. My goal is to have a code that allows you to choose a file from excel and then from that file import the data to a table I have in access.
The thing is that when the information is transferred to the Access table all the data is pasted , lets say 400 rows, but in addition ALL the blank rows from the excel file -around 15000 rows -. Do you know why this is happening?
I would like to only paste the data not the blank rows.
Thanks in advance!