Excel Xml Import Error Data Source Not Found
Contents |
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryWikiLearnGalleryDownloadsSupportForumsBlogs Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My excel xml import error no data was imported Forums Answered by: Cannot find data source while adding a
Excel Xml Import Error No Elements Mapped
XML mapping data source Microsoft Office > Excel IT Pro Discussions Question 0 Sign
Excel Microsoft Odbc Driver Manager Data Source Name Not Found And No Default Driver Specified
in to vote Product : Excel 2007 (also unseccesfully try with Excel 2010) I had a look at the following features : http://office.microsoft.com/en-ca/excel-help/import-xml-data-HP010206405.aspx?CTT=3
Install Odbc Driver For Excel
http://office.microsoft.com/en-ca/excel-help/overview-of-xml-in-excel-HA010206396.aspx?CTT=3 Usecase : A XML file is hosted on a web server using authentication. In a new workbook, I add a datasource from the web using the data tab. I am prompted my login/password. Once authenticated, the preview is filled with the XML body. Once clicked on "import", I'm odbc driver manager data source name not found and no default driver specified windows 7 promted whether I want to fill the current sheet or add a new one with the data. I choose to add a new worksheet and click OK. A new worksheet is added to the workbook and filled with data from the XML file. I can right click on any cell in the table to update the data. Then, I close the workbook. If I open it later and try to update the data, it fails displaying an error message : "Cannot find the data source" just as if the given URL is not a valid one. If I unzip the workbook package and open the connection file, the URL stored in it is the one provided; If I copy it and open it in any browser (IE, firefox, opera), the XML is displayed after authentication. We tried to store the XML file
Forum Microsoft Office Application Help - Excel Help forum Excel General Excel 2007 : "Data Source Not Found" when refreshing .xml source from web site To get replies by our experts at nominal charges, follow this link to buy points and post your thread in our Commercial Services forum! Here odbc connector 32bit is the FAQ for this forum. + Reply to Thread Results 1 to 2 of 2 excel odbc connection to oracle Excel 2007 : "Data Source Not Found" when refreshing .xml source from web site Thread Tools Show Printable Version Subscribe to this Thread… Rate This data source name not found and no default driver specified sql server Thread Current Rating Excellent Good Average Bad Terrible Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 01-07-2011,12:39 PM #1 snartc View Profile View Forum Posts Registered User Join Date 01-07-2011 Location Edmonton, Alberta https://social.technet.microsoft.com/Forums/en-US/2229b08a-39a4-4c0d-8d2e-c6286b199e23/cannot-find-data-source-while-adding-a-xml-mapping-data-source?forum=excel MS-Off Ver Excel 2003 Posts 2 "Data Source Not Found" when refreshing .xml source from web site I am having some trouble with a mapped .xml data source. I'm trying to set up an external source so that I can distribute a template to some vendors and have them refresh data down the road. I've mapped five tables as an XML data map and all works perfectly as long as the data source is on our internal network. Obviously, since I intend to http://www.excelforum.com/showthread.php?t=759151 send this outside the company, that won't help me with the final product. Unfortunately, the only place I have where I can publish the files will require users to log in with a username and password. (Neither is sensitive and can be saved with the template in clear text.) I have successfully mapped the data from the website (using the Data -> Import XML menu option.) I can also refresh the data from the website up until the time that I close Excel. I can close and reopen the file, but if I close Excel completely I get an error message the next time I attempt to refresh the data. If I then re-import the data for any one of the tables (which provides me with a password prompt), I can refresh the data for all of them. Any suggestions for how I might retain the password in the XML data source definition? Or trick Excel into entering the password for me? (I have tried the obvious one of picking the "remember password" option and have also tried logging into the website manually before doing the refresh.) I'd prefer not to have to remap the data every time I do a refresh... Cheers and thanks in advance, Corey Register To Reply 01-07-2011,02:37 PM #2 snartc View Profile View Forum Posts Registered User Join Date 01-07-2011 Location Edmonton, Alberta MS-Off Ver Excel 2003 Posts 2 Re: "Data Source Not Found" when refreshing .xml source from web sit
trouble with a mapped .xml data source. I'm trying to set up an external source so that I can distribute a template to some vendors and have them refresh data down the road. I've mapped five tables as an XML data map and http://www.teachexcel.com/excel-help/excel-how-to.php?i=110766 all works perfectly as long as the data source is on our internal network. Obviously, since I intend to send this outside the company, that won't help me with the final product. Unfortunately, the only place I have where I can publish the files will require users to log in with a username and password. (Neither is sensitive and can be saved with the template in clear text.) I have successfully mapped the data from the website (using the Data -> Import data source XML menu option.) I can also refresh the data from the website up until the time that I close Excel. I can close and reopen the file, but if I close Excel completely I get an error message the next time I attempt to refresh the data. If I then re-import the data for any one of the tables (which provides me with a password prompt), I can refresh the data for all of them. Any suggestions for how I might retain the excel xml import password in the XML data source definition? Or trick Excel into entering the password for me? (I have tried the obvious one of picking the "remember password" option and have also tried logging into the website manually before doing the refresh.) I'd prefer not to have to remap the data every time I do a refresh... Cheers and thanks in advance, Corey Free Excel Help Forum - Ask any question about Excel and have it answered in no time. Similar Excel Tutorials Make a Drop Down List Menu in a Cell in Excel I'll show you how to make a drop down list menu in a cell in Excel. This allows you to have a list appear when yo ... Combine Data from Multiple Worksheets in Excel The easiest way to combine and consolidate data in Excel. Simple method to combine data from multiple worksheets i ... Return the Min or Max Value Using a Lookup in Excel - INDEX MATCH Find the Min or Max value in a range and, based on that, return a value from another range. This is an advanced lo ... Update, Change, and Manage the Data Used in a Chart in Excel In this tutorial I am going to show you how to update, change and manage the data used by charts in Excel. This tut ... Helpful Excel Macros Basic Web Query in Excel - Import Data from the Web into Excel - Import data from the web into E