(Msg. 1) Posted: Fri Jun 06, 2008 9:06 am
Post subject: Parameter query Add to elertz Archived from groups: microsoft>public>excel>querydao (more info?)
I want to do an ODBC database query using values from the spreadsheet in the
query. I created the query in MS Query using typical values. Then in MS
Query, I set up parameter and ran the query. Everything worked well. Then
when I hit the button to return the data to Excel, MS Query went away as
usual but Excel returns the error: [ODBC Driver manager][ODBC]Driver does not
support this function.
I don't understand why, if the query works in MS Query, why it won't work in
Excel. They both use the same driver manager, don't they?
(Msg. 2) Posted: Sun Jun 29, 2008 9:57 pm
Post subject: Re: Parameter query Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
"Todd" <Todd.DeleteThis@discussions.microsoft.com> wrote in message
news:CC0C80E8-43C8-4F3C-B272-E3778C0367FE@microsoft.com...
> I want to do an ODBC database query using values from the spreadsheet in
> the
> query. I created the query in MS Query using typical values. Then in MS
> Query, I set up parameter and ran the query. Everything worked well. Then
> when I hit the button to return the data to Excel, MS Query went away as
> usual but Excel returns the error: [ODBC Driver manager][ODBC]Driver does
> not
> support this function.
>
> I don't understand why, if the query works in MS Query, why it won't work
> in
> Excel. They both use the same driver manager, don't they?
(Msg. 3) Posted: Mon Jun 30, 2008 5:01 am
Post subject: Re: Parameter query Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Thank you for the reply. The answer is, in short, yes I followed the procedure.
I even ran through it again, following your instructions. All went well up
to the point where I returned the data to the spreadsheet. I got to the
Parameters window and entered them per instructions and hit OK. This took me
back to the Import Data window, where I hit the OK button again. That's where
I got the error in the original posting. I just don't understand why
everything would work in Microsoft Query but not in Excel itself. Unless
Excel passes the parameters to the database driver differently than Microsoft
Query does.
Again, thank you for your help.
Todd
"Nick Hodge" wrote:
> Todd
>
> Have you taken a look here?
>
> http://excelusergroup.org/blogs/nickhodge/archive/2008/01/24/importing...ta-with >
> --
> HTH
> Nick Hodge
> Microsoft MVP - Excel
> Southampton, England
> nick_hodgeTAKETHISOUT.TakeThisOut@zen.co.ukANDTHIS
> web: www.excelusergroup.org > web: www.nickhodge.co.uk >
>
>
>
>
> "Todd" <Todd.TakeThisOut@discussions.microsoft.com> wrote in message
> news:CC0C80E8-43C8-4F3C-B272-E3778C0367FE@microsoft.com...
> > I want to do an ODBC database query using values from the spreadsheet in
> > the
> > query. I created the query in MS Query using typical values. Then in MS
> > Query, I set up parameter and ran the query. Everything worked well. Then
> > when I hit the button to return the data to Excel, MS Query went away as
> > usual but Excel returns the error: [ODBC Driver manager][ODBC]Driver does
> > not
> > support this function.
> >
> > I don't understand why, if the query works in MS Query, why it won't work
> > in
> > Excel. They both use the same driver manager, don't they?
>
>
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
Search
Profile
Private Messages
Log in/Register/Password
Office