Importing Text File

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi have a .txt file that is not importing corrrectly. When i do an import I
get errors in the two fileds that I must have. They contain numbers and when
I try to import the numbers are excluded and and error file is created with
type conversion error. Is there a work around for this?
 
Yes, there's usually a workround. Possibly all you need to do is create the
table first (in the usual way) and then import the data into it. On the other
hand many problems importing from text files are caused by irregularities in
the data or the structure of the file.

Without knowing more about the structure and contents of the file there's
not much more that can be said.
 
In Excel, try adding a new row under your field header names with a string
of alpha characters in each field EX:
"aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa"
When Access import process scrutinizes the data set to auto-define the field
types, it will determine that the data type for all columns is either text
or memo, depending on the number of apha characters you added. After the
import is successful, delete the bogus row, and reset the field type if need
be.
 
Back
Top