OLE DB

Hello Community,

Hope you're fine! Just started to learn applying OLE DB in BP... I've studied online how to configure queries and I think that I'm understanding it well. However, this is not working and BP answers with this error: "Internal: Could not execute code stage because exception thrown by code stage: Invalid argument."

What I want to do is to extract a single column without headers from excel file... Is anything worng in my query? Could you guys help me out here?

Also, if you know some tutorial content that I should see, I appreciate it!

Thanks for your atention,

Rita

View attachment 5921
 

ewilson

Member
Have you tried using the MS Excel VBO available on the Digital Exchange? You can get an entire worksheet as a collection and then just whittle it down to what you want.
 
Top