import error

[Carter Johnson]

I have source data in a .txt file. The file contains many fields,
including Transaction_Date. The Transaction_Date is in the following
format: 28-JUL-2003.

When importing the data to an existing Access database, Access imports
all fields except the Transaction_Date data. Access gives me an Import
Errors table-Type Conversion Failure.

What is the cause of this and how can I fix it?

 

[Van T. Dinh]

In the first dialog of the Import Text Wizard, there is
an "Advance" button. You probably need to use this to set
up / tell Access of the date format of your source so that
it can import properly.

HTH
Van T. Dinh
MVP (Access)

 

[Carter Johnson]

Thanks! It worked!

In the first dialog of the Import Text Wizard, there is
an "Advance" button. You probably need to use this to set
up / tell Access of the date format of your source so that
it can import properly.

HTH
Van T. Dinh
MVP (Access)





the following


Access imports


me an Import

 

[Guest]

I have the same error with a non-date field - SKUs. I have tried setting the
data type to text and memo to no avail. The only fields that import are those
that begin with 0 - however the SKU appears without the zero. Ex. SKU =
0838..., table shows 838...

Please advise if you have a moment.