Importing Excel File with Longitude and Latitude help

[#1]

HI,

Im trying to import an Excel file with Longitude and Latitude but when I run the import script the '.' are converted into ',' (comma's).  How can I keep the format of the these fields?

This is my import script :

LOAD

     lat,

     lng,

     Item

FROM

C:\uk_test.xlsx

(ooxml, embedded labels, table is uk_test);

Many thanks for any help!

Fiorano

[#2]

hi,

change environment varibale DecimalSep to '.'.

SET DecimalSep=',';

replace above statement with with below one

SET DecimalSep='.';

Niranjan M.

[jagan · Accepted solution]

HI,

Try like this

LOAD

    Text(lat) AS lat,

     Text(lng) AS lng,

     Item

FROM

C:\uk_test.xlsx

(ooxml, embedded labels, table is uk_test);

Regards,

Jagan.

[#4]

Hi I tried this and the latitude figures are now showing as single figures  : '5'

Fiorano