Take the 2-minute tour ×
Software Quality Assurance & Testing Stack Exchange is a question and answer site for software quality control experts, automation engineers, and software testers. It's 100% free, no registration required.

I know how I can connect to an Excel sheet as a database using the ADO objects, but as it is, I need to download the spreadsheet from Test Resources and store it locally. How can I connect to the spreadsheet in ALM without downloading it from Test Resources?

share|improve this question
add comment

1 Answer 1

If the file is available on the network you might be able to set up an DSN to use with and ODBC connection that you can use with the ADO objects. Here are a couple references that might help

Connect to Excel using ODBC in C# - a basic example in c# Unable to create DSN for Microsoft Office System Driver on 64-bit versions of Windows - some details around working around the 32/64 bit differences ins ODBC drivers for office.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.