How to force Access to scan entire imported file to determine field type?
Posted on 2011-10-21
I am importing Excel worksheets into an existing Access table and am having problems with the text being imported into a memo field being truncated at 255 characters. I think this is because Access scans the first 25 characters of the imported field to determine the field type and many of the Excel files being imported have short text fields in the first 25 rows so Access determines that it should import the field as a text field rather than a memo field. I seem to recall there being a way to force Access to scan the entire Excel file during the import to determine field type (not just the first 25 rows), but I can't remember how that was done. Am I correct in recalling that is possible, and if so, how is it done?