Connect to Excel file using QODBC/QODBC3 Qt driver

Question

How could I properly connect to Excel file using QODBC/QODBC3 Qt drivers?

At firs I built a driver like that (in cmd)

>cd %QTPATH%\src\plugins\sqldrivers\odbc

>qmake odbc.pro

>nmake

then qsqlodbc4.dll file has been created in %QTPATH%\plugins\sqldrivers

I used this code

    #include <QApplication>
    #include <QtGui>
    #include <QtSql>
    
    int main(int argc, char** argv)
    {
        QApplication app(argc, argv);
        //QComboBox myCombo;
    
        //excel stuff
        QSqlDatabase dbExcel = QSqlDatabase::addDatabase("QODBC","dbExcel");
            // i thought mayde that would work
           // dbExcel.setDatabaseName("C:\databases\test.xlsx");

           //i tried connection string too
          dbExcel.setDatabaseName(QString("DRIVER={Microsoft Excel Driver (*.xlsx)}; READONLY=FALSE; FIL={MS Excel}; DBQ=C:\databases\test.xlsx"));
        
        if(!dbExcel.open())
        {
            QSqlError er = dbExcel.lastError();
            QMessageBox::information(0, "Error", er.text());
        }
    
    
        
         //...................
    
        
    
        return app.exec();
  }

and there I cathed that error (it translates like:

[Microsoft][ODBC driver manager] Data source not found and default driver not set. QODBC3: Unable to connect

)

error

UPD

Also it says that drivers are avalible

QSqlDatabase: available drivers: QIBASE QSQLITE QODBC3 QODBC

You will definitly need to use the DSN call dbExcel.setDatabaseName(QString("DRIVER={Mic.... — Sebastian Lange
– Sebastian Lange, Commented Oct 16, 2013 at 6:34
@SebastianLange well I tried like this dbExcel.setDatabaseName(QString("DRIVER={Microsoft Excel Driver (*.xlsx)}; READONLY=FALSE; FIL={MS Excel}; DBQ=C:\databases\test.xlsx")); but it didn't worked. also made it uncommented in code to not confuse people anymore :) — DanilGholtsman
– DanilGholtsman, Commented Oct 16, 2013 at 6:39
@Rachael well, I used QAxObject stuff, as far as I remember qt-project.org/wiki/Using_ActiveX_Object_in_QT qtforum.org/article/22557/activeqt-excel.html — DanilGholtsman
– DanilGholtsman, Commented Feb 20, 2015 at 17:55
Ah! You've made my weekend. Thank you. Another curious question. Are you using MS SQL with QT and if so, how have you been successful at connecting to it without ODBC? — Rachael
– Rachael, Commented Feb 20, 2015 at 18:01

Shunya · Accepted Answer · 2022-06-04 09:59:49Z

0

Wrong: DBQ=C:\databases\test.xlsx

Correct: Use double \ in addr

edited Jun 4, 2022 at 9:59

Shunya

2,5244 gold badges20 silver badges36 bronze badges

answered Jun 2, 2022 at 10:59

user19255857

11 bronze badge

Sign up to request clarification or add additional context in comments.

1 Comment

Community Over a year ago

Your answer could be improved with additional supporting information. Please edit to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers in the help center.

Collectives™ on Stack Overflow

Connect to Excel file using QODBC/QODBC3 Qt driver

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related