How to open Excel sheet with full access in c#?

Excel 2003: comparing and updating similar spreadsheets?

• (I do not have access to Access) Main Issue: I have 3 spreadsheets. Each have a Last name and a First name. The main sheet is a little out of date and I need to update it using the other 2 sheets which have between 2000-2500 rows. I have tried few formulas however I can only compare each column and need it so it looks at both A,B at the same time to find difference (ex. There are several Brians (First name),only one Walsh and several Weavers(Last names), Brian Weaver left but Will Weaver is here and Brian Walsh is here. So it is coming back saying there is a Brian and a Weaver but I need it to say there is no Brian Weaver) If you want to help with the full problem: Main sheet and new contact list: I needs to find a way for it to compare Last (column A) "and" First (Column B) names for any difference. Delete any employees who left (Are not in the New Contact List)and add any new employees not found in the main sheet and their 3 other columms (D,E,F) from the New Contact list to the Main Sheet. Main Sheet and Mobile Devices: I need them to compare names (Column A(Last), B(First)) if they have a mobile device (Yes or No, Column H), and Input mobile name (Column G). It sounded simple until I learned I couldn't use SQL or ACCESS and Excel 2003 was a little before the time I started to use Excel.

• Answer:

  Sounds like a job for VBA (Visual Basic for Applications) - that's the procedural language that Microsoft developed that can sit behind things like a spreadsheet and do more complex things than the basic app functionality. It's a far more complex subject than I could possible describe here however...might want to search the MS site for videos or tutorial docs.