When I link data from an Excel file, one of the fields could potentially have longer than 255 characters. Access does not allow me to change the property of the linked file to Long Text. How do I overcome this issue?
When I link data from an Excel file, one of the fields could potentially have longer than 255 characters. Access does not allow me to change the property of the linked file to Long Text. How do I overcome this issue?
Msoft has problems with Long Text, since it wants to import everything at 255 chars. (thank them)
I've had some success importing XL into a memo, but it's been a while.
Have you tried to edit the Excel file by adding in the first row more than 255 characters in that field and relinking?
Cheers,
You're welcome. When linking Excel files the wizard looks at the data in the first few rows to determine the "appropriate" data type for the linked table.
Cheers,