“CELLSNET-46829 - DBConnection object…” works great, thanks!
Regarding “Queries” and the example file “Excel Master Test File.xlsx” above, you suggest the values I need will be in the
Using your revised DLL and processing this file, for one of the queries we get:
queryTable.ExternalConnection.SourceFile = null, and
queryTable.ExternalConnection.Command = "SELECT * FROM [Query2]".
The definition for queries are contained in the decoded mashup text (like the definitions for DBConnections are), i.e. for
Query2 you can see there is:
shared Query2 = let Source = OleDb.DataSource("Provider=Microsoft.ACE.OLEDB.12.0; Data Source=E:\...\child3.accdb;", [Query="SELECT * FROM 'E:\...\child3.accdb'.[Stuff];"]) in Source;
The values for
data source and
query are obtained from here, i.e.
Data Source=E:\...\child3.accdb;", and
Query="SELECT * FROM 'E:\...\child3.accdb'.[Stuff];"]
Perhaps these can be
These are the values need read/write functionality. Thanks!