Compare SQL to Excel

By sobryan ·
I have a SQL database that is modified daily. We continually receive spreasheets with data from our client.

I need to know if there is any off the shelf software that will allow me to compare database tables to the spreadsheets for changes/updates.

Any information would be helpful.


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

No off the shelf

by LarryD4 In reply to Compare SQL to Excel

I don't know of any off the shelf software to do the job. Though a VB or VBA written program could do what your asking. Just need someone who is experienced with VB, VBA, and accessing SQL tables.

Related Discussions

Related Forums