Hello Community,
Please help me with the following,
I want to filter data from an Excel file through an SQL Connection, in order to filter some items, but I have problems with Execute SQL Statement.
It throws me the following error:
Microsoft.Flow.RPA.Desktop.Modules.SDK.ActionException: Error en la instrucción SQL The Microsoft Access database engine could not find the object 'intercambio_proveedores_2022062'. Make sure the object exists and that you spell its name and the path name correctly. If 'intercambio_proveedores_2022062' is not a local object, check your network connection or contact the server administrator. ---> System.Data.OleDb.OleDbException: The Microsoft Access database engine could not find the object 'intercambio_proveedores_2022062'. Make sure the object exists and that you spell its name and the path name correctly. If 'intercambio_proveedores_2022062' is not a local object, check your network connection or contact the server administrator.
en System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
en System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
en System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
en System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
en System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
en System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
en System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
en System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
en Microsoft.Flow.RPA.Desktop.Modules.Database.Actions.DatabaseActions.ExecuteSQLStatement(Variant connectionString, Variant sqlConnectionVariable, Variant sqlCommand, Variant& result, Int32 timeout, Int32 getConnection)
--- Fin del seguimiento de la pila de la excepción interna ---
en Microsoft.Flow.RPA.Desktop.Modules.Database.Actions.ExecuteSqlStatement.Execute(ActionContext context)
en Microsoft.Flow.RPA.Desktop.Robin.Engine.Execution.ActionRunner.Run(IActionStatement statement, Dictionary`2 inputArguments, Dictionary`2 outputArguments)
Thanks
I know its solved but the best way to get dynamic sheet name 🙂
GL
Hey,
in your case it should be [intercambio_proveedores_2022062$]
instead of Sheet1$
The syntax to read an Excel sheet as a database is to suffix a $ sign to the sheet name as below.
select * from [Sheet1$]