I want to create a database in MySQL (because that's what my web host supports) from data that I have in a spreadsheet. I know how to write the MySQL commands to create the table, but to create the table elements I need to insert text and characters in the first position of all the rows in column A without losing the data in the rows -- just insert values that MySQL needs before the values that are there. I also need to insert a single quote in the first position of each row in column H without losing the data in the rows. Lastly, I need to extract all the rows and place them in a plain text file with a comma and a space inserted after the last value in each column. I don't know how to do this with the REPLACE function in EDIT. Can it be done without writing code? If so how? I MIGHT be able to auto-record a macro to run on the file, but my skills are somewhat rusty and MySQL is completely intolerant of syntax errors.
I hope this makes SOME sense.