With Excel 2016 64 Bit, I am attempting to create a DSN less connection in PowerQuery to a Quickbooks (version 14) company file. The driver for this is the QODBC driver.
Per QODBC documentation, I should be able to follow the following example syntax to make this connection:
sConnectString = "Driver={QODBC Driver for QuickBooks};DFQ=C:Program FilesQODBC Driver for QuickBookssample04.qbw;OpenMode=M;OLE DB Services=-2;"
So I've tried that in PowerQuery by going to the 'Data' tab > New Query > From Other Sources > From ODBC.
The connection string I use is: {QODBC_Test};DFQ=C:\Users\Public\Documents\Intuit\QuickBooks\Sample Company Files\QuickBooks Enterprise Solutions 14.0\Sample_Retailer_who_Tracks_individual_sales.QBW;OpenMode=M;OLE DB Services=-2
There is a table named 'Account' in this file, so I also add the following sql statement: Select * from Account
When I click 'ok', I get the following message:
'Unable to Connect
We encountered an error while trying to connect
Details: "ODBC: ERROR [iM002] [Microsoft][ODBC Driver Manager]
Data source name not found and no default driver specified.
Should I try to configure this as a connection from a Blank Query? Are DSN-less connections not an option for Power Query?
Thank you for your help.
Per QODBC documentation, I should be able to follow the following example syntax to make this connection:
sConnectString = "Driver={QODBC Driver for QuickBooks};DFQ=C:Program FilesQODBC Driver for QuickBookssample04.qbw;OpenMode=M;OLE DB Services=-2;"
So I've tried that in PowerQuery by going to the 'Data' tab > New Query > From Other Sources > From ODBC.
The connection string I use is: {QODBC_Test};DFQ=C:\Users\Public\Documents\Intuit\QuickBooks\Sample Company Files\QuickBooks Enterprise Solutions 14.0\Sample_Retailer_who_Tracks_individual_sales.QBW;OpenMode=M;OLE DB Services=-2
There is a table named 'Account' in this file, so I also add the following sql statement: Select * from Account
When I click 'ok', I get the following message:
'Unable to Connect
We encountered an error while trying to connect
Details: "ODBC: ERROR [iM002] [Microsoft][ODBC Driver Manager]
Data source name not found and no default driver specified.
Should I try to configure this as a connection from a Blank Query? Are DSN-less connections not an option for Power Query?
Thank you for your help.