Search results

Pat, thanks for the reply. Unfortunately, my import files are all CSV format and not really affected by XL file type formats. When I manually create an import spec for 'short text' into my Access table, the IP address come through properly. It is only when I leave all the settings to default...

I am now having this same issue with IP addresses being 'compressed' when imported from a CSV file via acImportDelim. The target field is set to 'short text' with 255 chars. Have tried to set up manual import specs that will give me the correct IP addresses but then I lose the date/time values...