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
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