Importing text file and data type conversion error

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
 
N

Nicawette

Dear Joseph,

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

Nicolas

Joseph Meehan a écrit :
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top