Hi,
I believe many of Access developers have been involved into working with Excel files (import/export) via VBA. So, I was hoping someone could help me with topic.
When I import the Excel file into Access table, I lose some data due to errors such data type conversion failure, etc.
Is there a way to control that? What are the best techniques to apply?
I will appreciate any tips as regards to Excel file handling in the Access.
Thanks.
I believe many of Access developers have been involved into working with Excel files (import/export) via VBA. So, I was hoping someone could help me with topic.
When I import the Excel file into Access table, I lose some data due to errors such data type conversion failure, etc.
Is there a way to control that? What are the best techniques to apply?
I will appreciate any tips as regards to Excel file handling in the Access.
Thanks.