Connection with DBF

okatsinis
Posts: 5
Joined: Thu Dec 29, 2016 1:22 pm

Connection with DBF

Postby okatsinis » Thu Mar 23, 2017 4:28 am

Is it possible to connect Power Query with DBF files?

User avatar
AndVGri
Posts: 31
Joined: Thu Jun 02, 2016 2:41 am
Location: Sankt-Peterburg

Re: Connection with DBF

Postby AndVGri » Thu Mar 23, 2017 4:24 pm

Hi.
Yes, you can

Code: Select all

let
    source = OleDb.Query(
        "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\DbfFolderPath; Extended Properties=dBASE IV;",
        "Select * From [DbfFileName.dbf]"
    )
in
    source

Regards,

okatsinis
Posts: 5
Joined: Thu Dec 29, 2016 1:22 pm

Re: Connection with DBF

Postby okatsinis » Fri Mar 24, 2017 3:38 am

Excellent. Thank you very much. WORKS!!!!


Return to “Power Query”

Who is online

Users browsing this forum: No registered users and 2 guests