Hi,

I have the code below at Access VBA. I would like to import an excel sheet in an excel workbook into access. I currently have this code:

Please Login or Register  to view this content.
When i run the code, it generates the following errors:
1. a new table created called "Workday data dump import error" listing fields named "Error", "Field", and "Row" --> it has records of "Type Conversion Failure"
2. the imported excel data suddenly has additional extra rows in access

i tried to do this manually by going to External Data > Excel (Import) but it's generating the second error (extra rows).

can anyone help me fix this?

thanks!