I cannot figure out why txt/cvs file, which has in one column this number 20110805070542000, can not be imported into Access DB as Number data type
I have test it to cut a few last numbers, and to have only this size 2011080507. This size of data has been imported without errors.
I have also change type with alter query, but then get a field result like this 2.01108E+16.
Dim fieldsize As String
fieldsize = " ALTER TABLE test " & _
" ALTER COLUMN field1 Number; "
Thank I have also try as Double, and get this result 2.0110805070542E+16.
Any idea? Can someone explain rules about data types, as I would like to have numbers size like this one 20110805070542000
Thank you in advance for help.