I have been trying to import an Excel document into my Access database using the External Data > Excel wizard.
Following through the wizard, I get to the screen where I can select what data type I would like for each field. I change these to "Memo" to allow the maximum character limit.
At this screen, I can see already that the data is being truncated (either that, or there is a limited column size width).
Once the data has finished importing into Excel, I open up the table and can see that the data has been truncated to 255 characters.
Before importing the data, I can see that Excel shows all characters in the formula field. There is no truncation.
I have also tried saving the data from Excel as CSV. Access does not import this correctly and seems to mix up the fields.
Why is Access doing this if the fields are set to Memo? How can I import the data?
Thanks,
Pter.