Yep, Same problem here... Are there any special options I need to check on the data source when import data from ARS to Excel using ODBC?
brgds Trond Valen - Steria AS Mobile: +47 913 36 275 [email protected] -----Opprinnelig melding----- Fra: Action Request System discussion list(ARSList) [mailto:[email protected]] På vegne av Carey Matthew Black Lagt inn: 14. juli 2009 20:01 Lagt inn i: Remedy Diskusjon: Excell data query Emne: Re: Excell data query Fred, I have no idea if a new patch has been pushed on to my pc since I last tried this "function". However, as of this moment, I see this for my copy of Excel. ( I assume it is as current as it can be.) Microsoft Office Excel 2007 (12.0.6504.5001) SP2 MS0 (12.0.6425.1000) ( I finally found this after poking about 4 buttons to find the good old "About Excel" that use to be under the Help menu. I hate it when programs change key mappings or menus.... grrrrRRRR. Sigh.) HTH. Do you know of any specific patch that helps/hurts/affects these features of Excel 2007? -- Carey Matthew Black BMC Remedy AR System Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On Tue, Jul 14, 2009 at 1:19 PM, Grooms, Frederick W<[email protected]> wrote: > Do you know which Office 2007 ServicePack level they are on? > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[email protected]] On Behalf Of Carey Matthew Black > Sent: Tuesday, July 14, 2009 12:01 PM > To: [email protected] > Subject: Re: Excell data query > > Steve, > > I can second the experience. > > But I can add that we are using Excel 2007 with ARS v6.3 and v7.1 and > the problem appears to exist against both ARS servers/ODBC drivers. I > like Kelly concluded that the commonality was Excel 2007 more than > ARS. It sure does not help me functionally, and it is a lot harder to > get my users to "blame Microsoft" (than BMC). So ultimately we hear > "Remedy doesn't work". We can all blame each other but at the end of > the day if the users can not get the job done, then ... other > processes/tools will be found. > > I have not had any time to try to fix it yet. Just to many bugs in all > the software that I use these days. :( > > -- > Carey Matthew Black > BMC Remedy AR System Skilled Professional (RSP) > ARS = Action Request System(Remedy) > > Love, then teach > Solution = People + Process + Tools > Fast, Accurate, Cheap.... Pick two. > > > On Wed, Jul 8, 2009 at 6:29 PM, Steve > McDonald<[email protected]> wrote: >> ** >> Has anyone had problems extracting data via Excel after upgrading to Excel >> 2007? >> >> I have a user that the following error: >> >> Unable to obtain a list of tables from the data source. He said >> spreadsheets created with Excel 2003 work ok but nothing new. >> >> We're on 7.1 patch 6 on Unix 10/Informix 10. >> >> >> Thanks _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" This email originates from Steria AS, Biskop Gunnerus' gate 14a, N-0051 OSLO, http://www.steria.no. This email and any attachments may contain confidential/intellectual property/copyright information and is only for the use of the addressee(s). You are prohibited from copying, forwarding, disclosing, saving or otherwise using it in any way if you are not the addressee(s) or responsible for delivery. If you receive this email by mistake, please advise the sender and cancel it immediately. Steria may monitor the content of emails within its network to ensure compliance with its policies and procedures. Any email is susceptible to alteration and its integrity cannot be assured. Steria shall not be liable if the message is altered, modified, falsified, or even edited. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
