Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Two huge tables - how to compare?
Message
De
15/04/2020 21:31:55
 
 
Information générale
Forum:
Office 365
Catégorie:
Excel
Divers
Thread ID:
01674053
Message ID:
01674054
Vues:
71
>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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform