Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Microsft Query: Excel, date parameter cell doesn't work.
For importing external data into Excel, I use Microsoft Query. If I use
parameter =#7/28/2005# in the query itself, it works, but it doesn't work if, in Excel, I want to "Get the value from the following cell" or "Use the following value". |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Microsft Query: Excel, date parameter cell doesn't work.
Ronco,
What happens when you use Get value from the following cell? What value is the cell you are using? What is the format of the cell? Date? I have no problems using a date field in a parameter MS Query. Although I have to use a specific format because the data I am querying uses a proprietary date format. "Ronco" wrote: For importing external data into Excel, I use Microsoft Query. If I use parameter =#7/28/2005# in the query itself, it works, but it doesn't work if, in Excel, I want to "Get the value from the following cell" or "Use the following value". |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Microsft Query: Excel, date parameter cell doesn't work.
Dominic, when I use the Get value from the following cell, an error msg box
"Bad parameter type. Microsoft Office Excel is expecting a different kind of value than what was provided." comes up. The cell format is Date 3/14/01. When I use a cell value of 7/28/05, it works, but the value =7/28/05 doesn't. The "=" part is what Excel doesn't like. I've tried every variation I can think of: =#7/28/05#, ='7/28/05', etc., but I still can't get it to work. I have to edit the query each time I want to change the date. "Dominic" wrote: Ronco, What happens when you use Get value from the following cell? What value is the cell you are using? What is the format of the cell? Date? I have no problems using a date field in a parameter MS Query. Although I have to use a specific format because the data I am querying uses a proprietary date format. "Ronco" wrote: For importing external data into Excel, I use Microsoft Query. If I use parameter =#7/28/2005# in the query itself, it works, but it doesn't work if, in Excel, I want to "Get the value from the following cell" or "Use the following value". |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Microsft Query: Excel, date parameter cell doesn't work.
Ronco, you should leave 7/28/05 in the cell.
The = goes in the Query Design grid in MS Query. For example: =[Parameter Name] instead of just [Parameter Name] Does that help? "Ronco" wrote: Dominic, when I use the Get value from the following cell, an error msg box "Bad parameter type. Microsoft Office Excel is expecting a different kind of value than what was provided." comes up. The cell format is Date 3/14/01. When I use a cell value of 7/28/05, it works, but the value =7/28/05 doesn't. The "=" part is what Excel doesn't like. I've tried every variation I can think of: =#7/28/05#, ='7/28/05', etc., but I still can't get it to work. I have to edit the query each time I want to change the date. "Dominic" wrote: Ronco, What happens when you use Get value from the following cell? What value is the cell you are using? What is the format of the cell? Date? I have no problems using a date field in a parameter MS Query. Although I have to use a specific format because the data I am querying uses a proprietary date format. "Ronco" wrote: For importing external data into Excel, I use Microsoft Query. If I use parameter =#7/28/2005# in the query itself, it works, but it doesn't work if, in Excel, I want to "Get the value from the following cell" or "Use the following value". |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Microsft Query: Excel, date parameter cell doesn't work.
Thanks, Dominic, it worked. That was so simple I'm embarrassed. It's the
input I needed for other queries as well. Thanks again. "Dominic" wrote: Ronco, you should leave 7/28/05 in the cell. The = goes in the Query Design grid in MS Query. For example: =[Parameter Name] instead of just [Parameter Name] Does that help? "Ronco" wrote: Dominic, when I use the Get value from the following cell, an error msg box "Bad parameter type. Microsoft Office Excel is expecting a different kind of value than what was provided." comes up. The cell format is Date 3/14/01. When I use a cell value of 7/28/05, it works, but the value =7/28/05 doesn't. The "=" part is what Excel doesn't like. I've tried every variation I can think of: =#7/28/05#, ='7/28/05', etc., but I still can't get it to work. I have to edit the query each time I want to change the date. "Dominic" wrote: Ronco, What happens when you use Get value from the following cell? What value is the cell you are using? What is the format of the cell? Date? I have no problems using a date field in a parameter MS Query. Although I have to use a specific format because the data I am querying uses a proprietary date format. "Ronco" wrote: For importing external data into Excel, I use Microsoft Query. If I use parameter =#7/28/2005# in the query itself, it works, but it doesn't work if, in Excel, I want to "Get the value from the following cell" or "Use the following value". |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Microsft Query: Excel, date parameter cell doesn't work.
You're welcome. Glad I could help.
"Ronco" wrote: Thanks, Dominic, it worked. That was so simple I'm embarrassed. It's the input I needed for other queries as well. Thanks again. "Dominic" wrote: Ronco, you should leave 7/28/05 in the cell. The = goes in the Query Design grid in MS Query. For example: =[Parameter Name] instead of just [Parameter Name] Does that help? "Ronco" wrote: Dominic, when I use the Get value from the following cell, an error msg box "Bad parameter type. Microsoft Office Excel is expecting a different kind of value than what was provided." comes up. The cell format is Date 3/14/01. When I use a cell value of 7/28/05, it works, but the value =7/28/05 doesn't. The "=" part is what Excel doesn't like. I've tried every variation I can think of: =#7/28/05#, ='7/28/05', etc., but I still can't get it to work. I have to edit the query each time I want to change the date. "Dominic" wrote: Ronco, What happens when you use Get value from the following cell? What value is the cell you are using? What is the format of the cell? Date? I have no problems using a date field in a parameter MS Query. Although I have to use a specific format because the data I am querying uses a proprietary date format. "Ronco" wrote: For importing external data into Excel, I use Microsoft Query. If I use parameter =#7/28/2005# in the query itself, it works, but it doesn't work if, in Excel, I want to "Get the value from the following cell" or "Use the following value". |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing cell contents so that Excel recognises it as a date | Excel Discussion (Misc queries) | |||
AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Excel 97 SR-1 / Set date in a cell-have day track in another cell | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions |