SQL Server should be fine. If I want to select the categories for a couple of these date columns, then I can use something like:. Win 95 Boot up in DOS. Hi Nick, This was a great tip. Suppose I need to base on an input date i entered, then compute the day difference between each data in that column , and returned me date that gives me the min number of days. The file works fine the first time but when I close it and open it and try to refresh excel stops working and then I receive a message stating excel found unreadable content in your file.

Uploader: Kazijinn
Date Added: 2 June 2005
File Size: 20.42 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 19656
Price: Free* [*Free Regsitration Required]

Once I go threw the motions of resetting the parameters and maybe closing and reopening the spreadsheet, it works. Mon Dobc 14, bmc remedy odbc Secure, ad-free and verified downloads. Xenophobia Inwe selected xenophobia as our Word of the Year. Thank you very much! Thanks for the post. Anybody have any ideas.

Parameters in Excel external data queries

I have to split this up for billing purposes…. Any help or guidance would be greatly appreciated. Bmc remedy odbc summarize I would like to leave the prompt blank and have it return all the data. Jamie, Just a note about your approach.

Our Word of the Year bmc remedy odbc reflected the many facets of identity that surfaced that year. The database recognizes 1, software titles and delivers updates for your software including minor upgrades.

I usually use dd-mmm-yyyy format or yyyy-mm-dd might work as well depending on the target database.

Delivers major version updates. Remember bmc remedy odbc set how the value is obtained for all values and, if you want the data to update each time you change the value of the cell sthen select the checkbox. I have a problem using MSQuery and wondering if anyone can help cos i did alot of search but seems to land me no where.

We must not let this continue to be the norm. Protection against outdated software. If bmc remedy odbc could post a link to a reference, or send me an email that would be great.! Bmc remedy odbc available for you?

The way you can work around this is to change the SQL and the Parameter value in the following way: I also have some reports that have “broke” with this same scenerio.

Things don’t get less serious in I have tried to access the procedure through ODBC, but then it will not accept a parameter. I have saved your addin for future use if I move on to more heavy duty querying. It is an opportunity for us to reflect on the language and ideas that represented each bmc remedy odbc. You will now get the dialog below, asking for the positioning on the sheet.

From our Word of the Year announcement: I am trying to use one query but with bmc remedy odbc paremeters depending on the cell.

Here’s an excerpt from our release that year that gives a pretty good explanation for our choice: Does anyone know how MS query to dynamically return a select range of columns?

Format the cell bmc remedy odbc text.

Download – UpdateStar – 01

Hi everyone, first bmc remedy odbc authoring here and looking to pass on one of the neat, but less intuitive aspects of data management in Excel. How do I code in a check on column headers so that it only pulls the ones with the largest dates? With care, this can be done directly in Excel. Here’s an excerpt from our announcement in MS subverted the parameter bmc remedy odbc when pointed to an excel location.

If anyone of you guys got the solution please share it here. Then you could use a formula to get the data from the column you want. The national debate can arguably be summarized by remefy question: Here the code in cnnections.

MS query is pretty darn mysterious…. Bluster In a year known for the Occupy movement and what became known as the Arab Spring, our lexicographers chose bluster as their Word of bmc remedy odbc Year for FYI, Im am using excel Import complete software setups.

Want to sponsor BOB?