I have been working on a program to pull data in from an Excel spreadsheet, merge and then update/insert information into a SQL Server table. Now the problem I ran into is that it won't update because of the following.
1) Your table names have to be the same
2) Your field names have to be the same
3) Your data types have to be the same
Now since I am unable to do this merge, what is another approach I can take to make this merge work?