Good afternoon, everyone.
Reading in the messages, I understand that to bypass the issue refer to the Excel importing procedure in Access (who checks the first 20 rows to decide the field type in the target table) is to use a CSV file. Actually, I'm not in the condition to ask to the user to save the file in CSV so I was thinking if there is a way in VBA to:
1. Open the received excel file (which has multiple worksheet),
2. Select one specific worksheet (e.g. Sheet1)
3. Save the new file which will contain only that worksheet in CSV format.
In this way i will then use that CSV to import in Access.
Appreciate your usual and kindly support.
Cheers.
Reading in the messages, I understand that to bypass the issue refer to the Excel importing procedure in Access (who checks the first 20 rows to decide the field type in the target table) is to use a CSV file. Actually, I'm not in the condition to ask to the user to save the file in CSV so I was thinking if there is a way in VBA to:
1. Open the received excel file (which has multiple worksheet),
2. Select one specific worksheet (e.g. Sheet1)
3. Save the new file which will contain only that worksheet in CSV format.
In this way i will then use that CSV to import in Access.
Appreciate your usual and kindly support.
Cheers.