Unable to connect CardStudio to an Excel based database created in Excel 2007

Article ID: 12123789

Details


 

Symptom 

Database Error when attempting to connect to an Excel 2007 Database using CardStudio. 

Applies to

Using CardStudio with an Excel file as a database

Resolution

Problem Resolution
Database Error

 

The Excel File must be compatible for use with CardStudio. CardStudio will only use Excel files with .xls extensions. (97-2003 Workbooks)

  1. Open the Excel 2007 file
  2. Click "Save As"
  3. Select Excel 97-2003 Workbook
     

This will save the file with a .xls extension and will allow CardStudio to use the file as a database.

 

Database Error

Resolution

The Excel File must be compatible for use with CardStudio. CardStudio will only use Excel files with .xls extensions. (97-2003 Workbooks)

  1. Open the Excel 2007 file
  2. Click "Save As"
  3. Select Excel 97-2003 Workbook

This will save the file with a .xls extension and will allow CardStudio to use the file as a database.