Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Two huge tables - how to compare?
Message
From
15/04/2020 21:31:55
 
General information
Forum:
Office 365
Category:
Excel
Miscellaneous
Thread ID:
01674053
Message ID:
01674054
Views:
72
>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform