Forum Discussion

rickscr's avatar
rickscr
Regular Visitor
8 years ago
Solved

Change query source with a parameter

I'm trying to change the data source of a query using a parameter, but I can't figure out the correct syntax. Here's my query:   let Source = OleDb.DataSource("Provider=Microsoft.ACE.OLEDB.12.0...
  • Anonymous's avatar
    Anonymous
    8 years ago

    rickscr,

    Change your code to  the following:

    let
    Source = OleDb.DataSource("Provider=Microsoft.ACE.OLEDB.12.0;Data Source="&FolderPath&";extended properties=dBASE IV", [Query="select * from [JunctOut.dbf]"])
in
    Source



    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

rickscr,

Change your code to  the following:

let
    Source = OleDb.DataSource("Provider=Microsoft.ACE.OLEDB.12.0;Data Source="&FolderPath&";extended properties=dBASE IV", [Query="select * from [JunctOut.dbf]"])
in
    Source



Regards,
Lydia

rickscr's avatar
rickscr
Regular Visitor
8 years ago

Perfect! Thanks!