Importing text file and data type conversion error

[Nicawette]

Dear all,

When I will import a text file with mixed data type (text, date,
number,...) into access I define the data type of each field but only
the data type "text" are imported.

There's a conversion problem and I don't know what it is exactly; do
you know how I can know what is the problem exactly?

I've text data that I want to convert into number with the following
format :" 62.01" ;for all of them the isnumeric function
give me the result that the data set is not numeric!.

The date with the format :"2006-10-26" are not imported but I think
that the dash is responsible for that?

what do you think?

PS I'm an "european" access user.

Nicolas

 

[Joseph Meehan]

Dear all,

When I will import a text file with mixed data type (text, date,
number,...) into access I define the data type of each field but only
the data type "text" are imported.

There's a conversion problem and I don't know what it is exactly; do
you know how I can know what is the problem exactly?

I've text data that I want to convert into number with the following
format :" 62.01" ;for all of them the isnumeric function
give me the result that the data set is not numeric!.

The date with the format :"2006-10-26" are not imported but I think
that the dash is responsible for that?

what do you think?

PS I'm an "european" access user.

Nicolas

There may be a better way, but I would try importing all the fields as
text type and then taking a look at what is there and then change the data
type in Access after making sure the data is all number.

 

[Nicawette]

Dear Joseph,

thank you for your answer but I've already tried this "workaround"

Nicolas

Joseph Meehan a écrit :