Converting excel file to comma seperated values

Hangin' Around Joined: Jan 18, 2006 Posts: 42

I am trying to import an SQL text file into MySql.

The file was exported from MySql so all the commands for creating tables and soforth are intact. What I want to do is modify a lot of the data that is comma seperated.

I pulled the file into excel and added the additional rows of data, but I don't know how to export it back to look like an sql text file. Whenever I try to make a comma seperated text file I always get double quotes and format errors.

How do you take data in a spreadsheet and convert it to look like this for example:

Quote:

INSERT INTO `nuke_bbposts` VALUES (5, 1, 6, 1, 1137384076, 'aca2240f', 'John', 1, 1, 1, 0, NULL, 0);

Posted: Mon Jan 30, 2006 7:07 am

Pmoney, You need to have each of the values in its own column (which you probably already have done) and then use one column at the beginning or at the end to use the concatenate function or manually do something like this in the formula cell:

="INSERT INTO `nuke_bbposts` VALUES ("&B1&", "&C1&", ".......etc...&");"

Make sure your string that you just created looks right and then copy the formula down the column for all the rows you need. Once you have this, you can select those strings and paste them into a good text editor, such as Textpad.

If the last copy and paste does not work for you, then you'll have to copy the column of strings again and do a Paste Special --> Values into another sheet within Excel and then you should be able to copy that and paste it into your test editor.

Posted: Mon Jan 30, 2006 1:50 pm

Cool, I'm familiar enough with that to make it happen. I just didn't know if there was some type of export that would keep it the way I want.

Thanks, will continue with my update project in this manner!