Importing CSV files
With "field names in your CSV-file" I guess you mean the cells in the first line of the file. It doesn't matter how they are named, but in fact it does matter how many columns the CSV-file has. You have to manually sort and (un-)check the columns in the listbox to reflect the structure of your CSV-file. There is no automatism yet which does this job for you.
Maybe this is a future thing for HeidiSQL. As I overthink that, I find that's a cool feature which should be posted to http://rfe.heidisql.com/ .
anyways, you'll have to enclose the values of a field with a special symbol .. for example the " (quote). and whenever this symbol appears as part of the value, you have to escape it with another symbol .. for example the \
"this is \"an\" example", "and this another one"
and i'm not sure if you had figured this out, be a return can be either \r\n, \r or \n, depending on which platform you are (window, mac, linux)
But, don't let stop you from Calc (Open Office)! It's much better the MS Office :)
Guys, I find a great tool to import CSV to Heidi and I wanted to share it with you.
On this page I get to convert an .csv file into an SQL command to import: convertcsv.com / csv-to-sql.htm And then I've copied the result text to Heidi and works perfectly
I've recently started using Heidi after a recommendation. My only problem is up until monday everything was fine. But since I have not been able to import a CSV file. I keep getting a connection error however there is no problem with the connection as I can run queries perfectly fine.
I can even run some of the import as insert statements. Worked fine for 40000+ records. However I need to get nearly 1.5million records into the table and doing it as inserts would take far too long.
It probably takes connection and then that connection dies on server as it's life time is probably limited on server or elsewhere.
That is, while it imports huge csv. Try to import to local server, if not already ...
Please login to leave a reply, or register at first.