By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of service , privacy policy and cookie policy , and that your continued use of the website is subject to these policies. We have tested this method, and could not get it to work in the UI. We tried changing drivers, configurations, etc. Post as a guest Name. Copy if newer Then it should work! Go through the steps of validating the file location, user access to the file and then the driver versions.

Uploader: Faurisar
Date Added: 24 November 2012
File Size: 47.96 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 14092
Price: Free* [*Free Regsitration Required]

When the Access Drivers are not installed or the bit version only is microwoft we will get an error regarding the data source not found. Not sure if this is viable in your case. This window will appear, and the ODBC Table Name, as entered in thewill be the same as the one defined in this window.

Make sure the user has correct rxcel within the windows folders. In my example here, it is the DefaultDir. I also added the file to the list of Deployment Items so the excel file is deployed to the out folder of the TestResults folder when the test is run. The name of the file is Test. The first step on fixing this issue is to determine what connection is being made and then miceosoft which ODBC driver to install or valid on the current machine or machine that is producing the error.


Home Search Tags Glossary Members.

If using a query that is more advanced, the will return the following error when testing the ODCB Connection: If this microsovt does not work, try to create a ‘named range’ and use that as some kind of table name. For example, if you are currently editing the spreadsheet, and testing it in the UI, it odcb fail, and give the following error message: It looks like you’re new here.

I had the same problem when deploying my tests with mstest. The file name is displayed in the Query window.

Excel dynamic range | eOne Solutions

By default, it will use the first rows in the region, and use their values as column names. Certainly saving the Excel spreadsheet as compatible a. By using our site, you acknowledge that you have read dobc understand our Cookie PolicyPrivacy Policyand our Terms of Service.

While SmartConnect uses ODBC for connecting to many different data sources the drivers required for those connections are going to be specific to the environment and may even differ per user machine and server.

March edited March in – XESame. Typical messages will state the driver has not been installed. To make connecting to these files quicker and easier, SmartConnect contains a list of Excel versions that can be selected or we can just pick Text File from the source list and pick our file.

When I run this test, here is the error I get: So, after you connect, you see exactly what’s in there and what name it has. Copy if newer Then it should work! Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. If this does not help, you could try to use the name you gave to the ODBC connection as table name in the from.


Excel dynamic range

Ben Breen 10 Make sure the object exists and that you spell its name and the path name correctly. INFO Article not rated yet.

I am sure you are wondering how do I know what drivers are installed on the machine. The excel file is in the root folder of the project. Each workstation where SmartConnect is running will have its own set of ODBC Drivers installed so while a map pointing to Excel on one machine works, it is possible that another machine does not have exce, same set of drivers loaded and the connection cannot be made.

We tried changing drivers, configurations, etc. To fix this problem you have got to change the properties of the Excel-File. To prevent spam users, you can only post on this forum after registration, which is by invitation.