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 ...
Marsha_R's avatar
Marsha_R
Icon for Champion Level 3 rankChampion Level 3
11 years ago

Are you trying to compare Excel to Access or Excel to Excel?

  • 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.