Importing Ip Addresses From Csv File – Truncated

[peterlaursen]

First  all: your link does not work!

 

Please tell: what localisation(s) do you have of Windows and Office? English only? It looks like the truncation happens inside the ODBC driver where it is assuming “.” as decimal sign (and not “,” as used in most non-English speaking countries). 

 

Anyway .. we will check this and see what can be done. 

[cdthomp]

Hi, 

 

Thanks for your reply. I ended up using the Import CSV data using Load Local, once all the fields were already made and types set. That worked, though it doesn’t give me the opportunity to use the Where clause to limit the import. It wasn’t ideal, but it worked. Any chance of adding the Where to that dialog?

 

Thanks

[peterlaursen]

LOAD DATA is executed server-side and not inside SQLyog.  So this request should go to Oracle/MySQL and not to us. 

[Author]

Posts