Question Problem to Import IP Address column from csv file

stal

New member
Local time
Tomorrow, 06:33
Joined
May 23, 2012
Messages
2
I am doing a simple Auto import of multiple csv files from a folder, 2 of the columns that imported are filled with IP Addresses value.
once I do the import and 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 columns 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 to import:

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​
 

Users who are viewing this thread

Back
Top Bottom