Import Text Wizard

[Guest]

I am trying to import a text file using the Import Text Wizard. These are
fixed width
fields. The Import/Export Specifications are already entered in the
database. I get the error message : Not all of your data was successfully
imported. Error descriptions all say "Type Conversion Failure".

Is it possible to tell the data type from the test document?? What can I do
to find out why this data isn't being imported?

 

[Guest]

When you go through the wizardsteps you should see the option to set teh
datatypes for the fields. If you skip this and apply the default Access
presumes that the fields are as Access suggested. Maybe one of the fields
datatypes was wrongly suggested.

Maurice

 

[Guest]

Just tried that. What happens is that I end up with only 8 out of 35 fields.
Is it possible that since Access defaults to "Text" that these are the only
fields set as text in the Import document?

 

[Pat Hartman \(MVP\)]

The import wizard determines the data type of each column by examining the
first few rows (20, I think). If all the data in those rows is a date, the
wizard assigns the data/time data type. If all the data is integer, the
wizard assigns integer, etc. If subsequent rows violate the data type, they
will get type conversion errors.

If you know what the data types should be, go through the wizard and set
them manually.

 

[Guest]

Ok, have you looked at the advanced options to see if you can make the
appropriate changes there. You find this options in the wizard - button
Advanced. You do see the 35 fields when you are going through the wizard?

Maurice