Hi,
There is a resolution to this already, but was wondering if there is an alternative method.
I have several records in an Excel file which can contain fields of over 255 characters. Therefore, I set up the Access table field as "memo-type". Before importing, I need to create 10 or so dummy rows at the beginning of the Excel file with fields containing 255+ characters because this is how Access determines the field type. This works.
If I don't create the dummy rows, the fields are truncated further along the process to only 255.
Is there an alternative solution to this problem.
Many thanks and regards.
There is a resolution to this already, but was wondering if there is an alternative method.
I have several records in an Excel file which can contain fields of over 255 characters. Therefore, I set up the Access table field as "memo-type". Before importing, I need to create 10 or so dummy rows at the beginning of the Excel file with fields containing 255+ characters because this is how Access determines the field type. This works.
If I don't create the dummy rows, the fields are truncated further along the process to only 255.
Is there an alternative solution to this problem.
Many thanks and regards.