(Msg. 1) Posted: Thu Jan 10, 2008 3:24 am
Post subject: Using MS Query Archived from groups: microsoft>public>excel>querydao (more info?)
Hi
I'm trying to import data in excel using MS Query by declaring some
variables and setting their values, I also call up a
function(UDF)...I've used Case statement as well
The query results the data set and returns the data to excel
worksheet...
here's the thing or things....when i try to edit the query it just
shows me blank sql !!!
Plus is it possible to set the value of the variables from excel
sheet ??? if yes then how
(Msg. 2) Posted: Thu Jan 10, 2008 8:45 am
Post subject: Re: Using MS Query [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Have you looked at the parameters feature of MS-Queery?
You can link parameters to cells on a worksheet
ryanb.
<khan.wajid DeleteThis @gmail.com> wrote in message
news:d7e032ee-0bf8-4293-a390-e98ee8ae2d3d@i7g2000prf.googlegroups.com...
> Hi
> I'm trying to import data in excel using MS Query by declaring some
> variables and setting their values, I also call up a
> function(UDF)...I've used Case statement as well
>
> The query results the data set and returns the data to excel
> worksheet...
>
> here's the thing or things....when i try to edit the query it just
> shows me blank sql !!!
>
> Plus is it possible to set the value of the variables from excel
> sheet ??? if yes then how
>
>
> Thanks
>
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office