Forum Discussion
How to make a oledb connection?
I'm looking for a way to make a connection oledb however only against odbc option
In the Other (Outras), at the bottom there's a "Blank Query" option, click that one.
And then, when you have the formula bar, type:
= OleDb.Query
It'll show a small help about how you can use that function
You can use it like this:
= OleDb.Query("your connection string", "your query")You need to find out what connection string & query you need to type in :)
In the Other (Outras), at the bottom there's a "Blank Query" option, click that one.
And then, when you have the formula bar, type:
= OleDb.Query
It'll show a small help about how you can use that function
You can use it like this:
= OleDb.Query("your connection string", "your query")
You need to find out what connection string & query you need to type in :)
My Power BI Desktop doesn´t recognize
OleDb.Query
Is it possible to create an OLEDB connection to a file?