Hi Sir, I have one excel and that excel contains some cell with hyperlink of another sheet when i open another sheet by hyperlink and try to perform operation on this sheet then first sheets data gets updated and not current open how can i update current excel
That’s bcoz when you open the excel you might have specified the sheet name of your first sheet and bot is taking that excel sheet reference in a session. When you point to another sheet try to specify the sheet name where you want to make changes.
Parabéns, você consegue me dizer como faço para copiar 3 colunas de uma planilha e colar em outra planilha? Exemplo: Planilha "Entrada", copiar as colunas B, C e D, e colar na planilha "saida" nas colunas A,B e C. Mas preciso por banco de dados, pois as planilhas são pesadas, obrigado e espero que consiga me ajuda.
Please also post how to copy data from one sheet and paste in to another sheet(i mean copying filtered tables from one sheet and paste in to another) and also joins of sql
The link that you have provided for Microsoft Access database engine is throwing error. It is showing like "we're sorry, this download is no longer available" can you please provide some alternate Microsoft Access database engine link to download.
Hi Sir,
I have one excel and that excel contains some cell with hyperlink of another sheet when i open another sheet by hyperlink and try to perform operation on this sheet then first sheets data gets updated and not current open how can i update current excel
That’s bcoz when you open the excel you might have specified the sheet name of your first sheet and bot is taking that excel sheet reference in a session. When you point to another sheet try to specify the sheet name where you want to make changes.
Parabéns, você consegue me dizer como faço para copiar 3 colunas de uma planilha e colar em outra planilha?
Exemplo: Planilha "Entrada", copiar as colunas B, C e D, e colar na planilha "saida" nas colunas A,B e C. Mas preciso
por banco de dados, pois as planilhas são pesadas, obrigado e espero que consiga me ajuda.
Any idea how we can read using sql for sheet with header not on first row
Where are your headers if not one first row?
Please also post how to copy data from one sheet and paste in to another sheet(i mean copying filtered tables from one sheet and paste in to another) and also joins of sql
Same set sel command I think
Excellent video 👏👏
Thank you!
Can you post the connection string here
It's already mentioned in the description. Please check.
The link that you have provided for Microsoft Access database engine is throwing error. It is showing like "we're sorry, this download is no longer available" can you please provide some alternate Microsoft Access database engine link to download.
Please try - www.microsoft.com/en-us/download/details.aspx?id=54920
Hi,
Can you please rpa developer roles and responsibilities
Sure, will be creating a video on this topic.
@@RPAFeed Thank you
I am not able to install odbc drivers which you mentioned - it was showing error
What error are you facing?
I'm getting error lyk could not connect to database.provider cannot be found. It may not be properly installed. How to solve this issue?
Check if you have installed the odbc driver
While connecting to db I got an error like
Could not connect to Database. Cannot update. Database or object is read-only.... Pls tell me the solution
Try using IMEX=1 at the end of the connection query.
What about Insert query man?
You can use insert queries and the data would be inserted in the same session.
can you please make video on SAP Excel
I can but SAP doesn't provide free access and can't use the enterprise edition for demo purposes.
Keep the database scheme in cache untill bot finished running is to check or uncheck
Which action or package are you talking here?
Getting error on sheet1
What is the error?