Forum Discussion

fkr717's avatar
fkr717
Occasional Contributor
11 years ago

Database checkpoint with Excel Workbook

I watched a you tube video on using excel as a source of data for a database checkpoint.  I downloade the Access Database Engine 12.0 64bit, but when I go to create a connection to the datasource, I ...
fkr717's avatar
fkr717
Occasional Contributor
11 years ago

Trying to compare a SQL database to a spreadsheet of data. 

Marsha_R's avatar
Marsha_R
Icon for Champion Level 3 rankChampion Level 3
11 years ago

The Database Checkpoint is going to compare a database to a saved copy of the same database in the same format.  With your two different formats, I think you'll have to use DDT to loop through the two sets of data and compare them.