I have an OpenDocument spreadsheet file which I've been using as a very (very very) basic personal database, and I'm trying to expand some of the features (namely being able to bring up different sets of matching records at my whim).
<br><br>I've exported the data to a .csv text file but I'm at a loss as to how to parse the file to get it into the right format. I've been following <a href="http://www.webdevelopersnotes.com/tutorials/sql/mysql_course_inserting_data_in_mysql_tables.php3">
http://www.webdevelopersnotes.com/tutorials/sql/mysql_course_inserting_data_in_mysql_tables.php3</a> and the sample table works great. The author used a .dat text file with the data in this format;<br><br>INSERT INTO employee_data (f_name, l_name, title, age, yos, salary, perks, email) values ("John", "Hagan", "Senior Programmer", 32, 4, 120000, 25000, "
<a href="mailto:john_hagan@bignet.com">john_hagan@bignet.com</a>");
<br>INSERT INTO employee_data (f_name, l_name, title, age, yos, salary, perks, email) values ("Ganesh", "Pillai", "Senior Programmer", 32, 4, 110000, 20000, "<a href="mailto:g_pillai@bignet.com">
g_pillai@bignet.com</a>");<br><br>For me to do the same (for thousand of records by hand) is ludicrous and error-prone. But I'm not sure how I am to automate the process of separating each record and then pulling it back together into a 'INSERT INTO data () values ();' format.
<br><br>Any suggestions as to what to use?<br><br> -jordan<br>