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 don't see the Microsoft Office 12.0 Access Database Engine listed in the Data Link helper. 

 

I have searched the forums and the internet, can't seem to find a way to use Excel as a datasource for a database checkpoint.

 

The issue really is trying to find an efficient way to provide the data table with the check data in it. 

 

Any help would be greatly appreciated, I am sure I am not the first person to try and solve this, just can't find any clear guidance that works.

 

Thanks

Kurt

3 Replies

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