[Solved] Inserting records from csv

jza · Post by **jza** » Wed May 24, 2017 2:00 am

I have a CSV and want to insert its data into a ODB table. I tried the SQL statements and can't use INSERT INTO... also tried just copy pasting but didnt work for multiple records. Any other ideas.

edit this topic's initial post · Post by **Villeroy** » Wed May 24, 2017 1:27 pm

Depends on the csv.

Post by **charlie.it** » Wed May 24, 2017 6:48 pm

jza wrote:I have a CSV ...

Ciao, can we see the file?

jza · Post by **jza** » Wed May 24, 2017 9:35 pm

Thanks I solved it by adding the whole SQL sentence to each row.

edit this topic's initial post · Post by **Villeroy** » Wed May 24, 2017 11:26 pm

I don't understand. Would you mind to share your solution with us?

jza · Post by **jza** » Wed May 24, 2017 11:43 pm

I insert the cv fields withing the VALUES() of the INSERT INTO table (column...) VALUES (csv-values....)

[Solved] Inserting records from csv

[Solved] Inserting records from csv

Re: Inserting records from csv

Re: Inserting records from csv

Re: Inserting records from csv

Re: Inserting records from csv

Re: Inserting records from csv