Problem while import IP Address column

[stal]

I am doing a simle Auto import of multiple csv files, 2 of the column I import is filled with IP Addresses value.


once I do the import, after checking the table I realize that the entire IP Addresses values are cut, for example
the real value is 192.113.13.80 and in the table I see 192.1131 this applicable for both the column and the entire rows. all other colomn imported correctly.
but, If I do a manual import for one of the files it being imported successfully. what can be the reason of the problem with the IP Address?

here is the code I use:

Dim f As Object '//File Object
With CreateObject("Scripting.FileSystemObject")
For Each f In .GetFolder("D:\Download\Msg\").Files
DoCmd.TransferText acImportDelim, , "Temp", f.Path, True, ""
Next f
End With

[Robeen]

I'm not certain of this - but just a suggestion . . .
It looks like Access is expecting the field to be a numeric field and it is importing it as ##.#### and leaving out the rest?
Again . . . not sure about that since I have never had this problem. But just looking at what Access DOES put in the field, looks like it may be interpreting the field as a numeric/decimal value.