?

This question has 2 parts:

First off, i have a spread sheet that i need to import to (an existing) mysql db. I have hard coded the primary Ids for the tables. Now the ids that i have hard coded do not work so i need to bump them up by about 7000. How do i do that?

Also is there an easy way to import Excel to Mysql directly? I do it by creating an access db from the excel and then using the mysql migration tool to import access to mysql.

Second, There is this one table A which has Ids say from 5000 - 15000 (these are the Ids i need to bump up as in question #1, anyway). Now these Ids are being used by other table, Say B, as a reference (i did not establish any reference in Excel. Don't know how to do that). But the problem is the use of these Ids is not consecutive. Meaning, table B may take 5000 - 5010 from A and then skip a 100 and then take 5110 - 8000 etc...

Now the questions is - If i bump all the Ids in table A by 7000 as in #1 is there a way to sync the Ids in table B also?

I don't know how much clear i was in explaining this issue, but please let me know if you need more clarity.

Thanks,

-K