Re HELP with this Macro Import

[Jay]

Here below is a sample of the data which I am trying to import. This import
of .txt data files. What happens is that I get a number of data conversion
errors. What I'd like to know is why, since the data is obviously text. Then,
again, maybe it's not! The actual data file has about delimited 49 columns.
Any ideas, will be welcome. Maybe, one of you guys may have a solution which
will work better!

Time FV_cor FV_nom Add Add_ca Di E Lot_Numb Mar Tin SKU_Code D_A_B
235914 005.13 005.02 225 002.09 80 R 00000000000 809 574 0203626551
235919 005.08 005.02 225 002.14 80 R 00000000000 809 574 0203626551
235926 005.09 005.02 225 002.12 80 R 00000000000 809 574 0203626551
235931 005.11 005.02 225 002.11 80 R 00000000000 809 574 0203626551
235945 005.09 005.02 225 002.14 80 R 00000000000 809 574 0203626551

Looking forward to your ideas and imput!

 

[Ofer]

If you trying import using Specification, check it, one of the field in it
might contain a number type, and while trying to import text you get that
error message.
Sometimes when you let access define the Specification Auto for you when it
see a number it define it as number even that it string. like 000111