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:
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!
Bookmarks