I'm trying to import a text file into an access database. It's not one I've written myself but the spec for the delimited text file is set up properly and the file imports properly using the wizard. When I try to use the import functions of the app itself, the ImportError table tells "Field Truncation" for one of the fields. Any help would be appreciated.
A:
I would suggest examining each column that you're bringing in, and then measuring that against your table column properties in table "Design" mode.
Common things I've seen throw this error are:
Imported text exceeding the 255 character limit of a field (in which case you can change the field type to memo)
Date fields being set up as short date format, and then trying to import long dates/times into the field.
Text other than "yes/no/true/false" being imported into Yes/No/True/False fields.
Double-check your columns for similar names, and then check the data being imported. Sometimes when multiple people are working on a project and appending data, columns with similar names can get confused...especially if the column is collapsed so that its name is not entirely showing.
ajax81
2010-04-24 19:49:38
"Short date" is a display format, not a data storage format. Any valid date format in an import source will be properly imported and converted to Jet/ACE's date format (which is a double, where the integer part is the day from 12/30/1899 and the decimal part is the time). Formatting of the target field has no effect whatsoever on imports -- only the text representation of dates in the import source has an effect. If it's valid, Jet/ACE will import it correctly.
David-W-Fenton
2010-04-25 15:56:15