import error

C

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?
 
V

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)
 
C

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
Click to expand...
 
P

Priya

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.
 
Top