Import CSV file - Field with numbers containing thousand space seperator

[ssanfu]

approx 1million records

Yes, that might take a while.

[ssanfu]

I just ran a test using the 5 records you provided.

Try this in a test dB..

I imported the CSV file to a table named "tmp". There was a field created in the tmp table named "Field1", type "Text"


I created a table named "Table1" with a field named "thousands", type "Number - Double"
Then I created a query:

INSERT INTO Table1 ( thousands )
SELECT Replace(Field1,' ',',') AS Expr1
FROM tmp;

I had to type this in the SQL editor

It imported the records from the tmp table to Table1 - no errors (5 records).
Don't know how this will work with the full dataset... but it is worth a try....