N
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
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