Page 1 of 1
[Solved] Inserting records from csv
Posted: Wed May 24, 2017 2:00 am
by jza
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.
Re: Inserting records from csv
Posted: Wed May 24, 2017 1:27 pm
by Villeroy
Depends on the csv.
Re: Inserting records from csv
Posted: Wed May 24, 2017 6:48 pm
by charlie.it
jza wrote:I have a CSV ...
Ciao, can we see the file?
Re: Inserting records from csv
Posted: Wed May 24, 2017 9:35 pm
by jza
Thanks I solved it by adding the whole SQL sentence to each row.
Re: Inserting records from csv
Posted: Wed May 24, 2017 11:26 pm
by Villeroy
I don't understand. Would you mind to share your solution with us?
Re: Inserting records from csv
Posted: Wed May 24, 2017 11:43 pm
by jza
I insert the cv fields withing the VALUES() of the INSERT INTO table (column...) VALUES (csv-values....)