>Hi everybody,
>
>I have 2 Excel files with 2 sheets in each of then. The biggest in one has 275,703 rows and the other file which is newer has 277,428 rows in total sheet. I want to only grab and load into SQL Server the different rows.
>
>I need to do this very urgently and I don't work much with Excel :( Is it something relatively easy to do? If yes, can you please help me with the step by steps instructions as I've been unsuccessful so far in figuring this out.
>
>Thanks in advance.
You may be able to import from excel into vfp tables to make things easier to work with. Then do your sql insert after getting the rows you want.
Here is one example. Note you may need to save your excel as a particular version for this to work.
https://www.tek-tips.com/viewthread.cfm?qid=1687044
Thanks,
Stacy
Black Mountain Software, Inc.