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). 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 http://www.webdevelopersnotes.com/tutorials/sql/mysql_course_inserting_data_in_mysql_tables.php3and the sample table works great. The author used a .dat text file with the data in this format; INSERT INTO employee_data (f_name, l_name, title, age, yos, salary, perks, email) values ("John", "Hagan", "Senior Programmer", 32, 4, 120000, 25000, " john_hagan at bignet.com"); INSERT INTO employee_data (f_name, l_name, title, age, yos, salary, perks, email) values ("Ganesh", "Pillai", "Senior Programmer", 32, 4, 110000, 20000, "g_pillai at bignet.com"); 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. Any suggestions as to what to use? -jordan -------------- next part -------------- An HTML attachment was scrubbed... URL: http://mailman.mn-linux.org/pipermail/tclug-list/attachments/20060509/bc7fe201/attachment.htm