First.. I'm NOT an Excel guy. NO VBA please! This must be in VB6 code.

Now then .. :-)

I get sent an excel file from a client. Sometimes it is multiple worksheets. I have an existing VB6 application running on MS SQL Server database.

I need to open each record in the Excel file, which is checked via email address...

If an email address already exists in SQL - flag the user with a warning message.....

If an email address does not exist - generate new unique identifyer and update the spreadsheet with this new ID....

I need some specific example code, and not (necessarily) pointers to KB articles, etc. This is my FIRST time dealing with this subject, so PLEASE be kind.

Thank you for your help -....