[Solved] Inserting records from csv
[Solved] Inserting records from csv
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.
Last edited by Hagar Delest on Sun May 28, 2017 9:03 pm, edited 2 times in total.
Reason: tagged [Solved].
Reason: tagged [Solved].
AOO 4.1.1 on Arch Linux
Re: Inserting records from csv
Depends on the csv.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
- charlie.it
- Volunteer
- Posts: 417
- Joined: Wed Aug 21, 2013 2:12 pm
- Location: Italy
Re: Inserting records from csv
Ciao, can we see the file?jza wrote:I have a CSV ...
charlie
Italian AOO Admin
macOS 14 Sonoma M1: Open Office 4.1.15 - LibreOffice 7.5.7.1
http://www.charlieopenoffice.altervista.org
Italian AOO Admin
macOS 14 Sonoma M1: Open Office 4.1.15 - LibreOffice 7.5.7.1
http://www.charlieopenoffice.altervista.org
Re: Inserting records from csv
Thanks I solved it by adding the whole SQL sentence to each row.
AOO 4.1.1 on Arch Linux
Re: Inserting records from csv
I don't understand. Would you mind to share your solution with us?
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Inserting records from csv
I insert the cv fields withing the VALUES() of the INSERT INTO table (column...) VALUES (csv-values....)
AOO 4.1.1 on Arch Linux