Software

Ask something
Question Locked

Compare SQL to Excel

0 helpful
2 replies

by sobryan

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

Thanks.

2 replies

by larryd4

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.

This discussion is closed to new replies.