Moving Contact Database

Hi, I suck with this stuff, and have worked my way into a corner I'm afraid.

I am moving our old contact database to a new program. In the old database, the company ID that contacts reference to see what company they belong to are unique nvchar50 type characters that look like GKDF-22DK-....

For the new program, the company ID's are INT type, so when I exported everything from my old database into excel files, and tried to import that into the new database, the types are off, so it breaks.

I have 1 workbook, 2 excel sheets. The first excel sheet is the company export, listing their ID, address, etc. The second excel sheet is the contact export, listing the companyID it belongs to, the contacts name etc.

What I realize I need is some type of mass find and replace script, that will look at each company record in the company sheet, search matching company ID's on the contact sheet, and replace all those matching values with an integer type of 1. then on the next record, do the same thing, and increase the integer to 2, and so on for each record. So that all the contacts now refer to the same company, only with a different ID type, that I can then import to this new program.

Any help would be so awesome.

I've already tried doing the above on the SQL side, but that mucks everything up when exporting the data to excel, which I need to do for import.