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?

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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