Forum Discussion

irrefutable14's avatar
irrefutable14
New Member
8 years ago
Solved

.DBF files as Data source

I have a folder of .dbf files  stored on a network folder that I want to have as a custom data set. I've researhed around and cant seem to find out how to make this work. I'd like to have it pull f...
  • v-ljerr-msft's avatar
    v-ljerr-msft
    8 years ago

    Hi irrefutable14,

     

    Here is a similar thread in which a solution is mentioned. Could you go to check if it works in your scenario? :smileyhappy:

    You could try the below:

     

    let
    Source = OleDb.DataSource("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=<Path to folder containing dbf file>;extended properties=<dbase version>", [Query="select * from [<dbf file name>.<dbf file extension>]"])
in
    Source

     

    Example:

    let
    Source = OleDb.DataSource("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\dbfFolder\;extended properties=dBASE IV", [Query="select * from [myFile.dbf]"])
in
    Source

     

    You'll need the Access Database Engine provider deployed.


     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
8 years ago

Hi irrefutable14,

 

Here is a similar thread in which a solution is mentioned. Could you go to check if it works in your scenario? :smileyhappy:

You could try the below:

 

let
    Source = OleDb.DataSource("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=<Path to folder containing dbf file>;extended properties=<dbase version>", [Query="select * from [<dbf file name>.<dbf file extension>]"])
in
    Source

 

Example:

let
    Source = OleDb.DataSource("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\dbfFolder\;extended properties=dBASE IV", [Query="select * from [myFile.dbf]"])
in
    Source

 

You'll need the Access Database Engine provider deployed.


 

Regards