Retrieving Data from Excel using OLEDB

Community
- Product Forum
  
  Get personalized help and advice from other SS&C Blue Prism users here.
- Digital Exchange
  
  Get community support for SS&C | Blue Prism® Digital Exchange assets and discuss the DX.
- SS&C Blue Prism Products
- Support Center
- Documentation
- First Steps
  
  Discover how to set up, deploy, maintain and support your SS&C | Blue Prism® Cloud or SS&C | Blue Prism® Enterprise solution.
- University Forum
  
  Upskill together with other SS&C Blue Prism learners. Share your learning objectives, get advice on courses and celebrate your latest certifications.
- Getting Started
  
  New to SS&C Blue Prism? Get advice on setup, deployment and organizational adoption.
- Blogs
  
  Your window to developer insights, customer stories, the latest company news, and more.
- Events
  
  Meet online or in person and discuss the world of intelligent automation.
- Product Ideas
  
  Submit and vote for your favorite ideas on how to improve SS&C Blue Prism products.
- Blueprints
  
  Intelligent automation use cases, shared by the teams who designed and deployed them.
- Product Research Program
  
  Help us meet your automation needs by participating in user research, beta trials and surveys.
- User Groups
  
  Find new friends and professional connections across the intelligent automation community.
- Welcome Space
  
  Find community news, activities, and tips here. You can also introduce yourself!
- Community FAQ
  
  Learn how to make the most of the SS&C Blue Prism Community.
- Community Suggestions
  
  Got an idea on how to improve the SS&C Blue Prism Community? Submit them, and vote on others, here.
- NHS Network
  
  A private area for NHS developers to network, collaborate and share best practices.
- Local Language
  
  Bienvenido! Salut! Witaj! Find intelligent automation professionals who speak your language here.
- Off-Topic Chat
  
  This space is for discussion about anything and everything – except intelligent automation!
- Local Government Network
  
  Discuss intelligent automation best practices and tactics for Local Government settings here.
- UK Higher Education Network
  
  Discuss intelligent automation best practices and tactics for Higher Education settings in the UK here.
- North America Healthcare Network
  
  Revolutionize the North American healthcare industry together with other intelligent automation professionals here. Please note: the content of this community is commercial in confidence, share with appropriate discretion.
- Japan Partner Tech Community
- Meet the Team
- Meet the MVPs

Is it possible to use OLEDB on an excel which is not saved physically, and just opens from certain actions in an end application? If yes, can someone guide me on how to set the connection string?

1 REPLY 1

I don't think so. Could you not save the file temporarily and then maybe delete after you are done?

SS&C Blue Prism Community

Retrieving Data from Excel using OLEDB