Posted to microsoft.public.excel.programming

Jeff[_63_] Jeff[_63_] is offline

external usenet poster

Posts: 1

vba error in sql call command

I'm getting error # -2147217887, ODBC driver does not support the
requested properties.

My sql command in a vba is summing category information for a range of
invoices. If I limit the range to 50 invoices, I get the data, but over
50 and I get the error.

Any thoughts ???

fwiw I've tested in both Excel 2003 and Excel 2007

Jeff

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Call command for Excel Wizard	ihh2716	Excel Programming	1	October 4th 08 04:26 AM
call a macro with arguments in a Command Button	Jeff	Excel Programming	1	November 9th 06 07:35 PM
Call particular Excel function from command line	[email protected]	Excel Programming	3	September 29th 06 03:47 PM
Call up build in excel command using macro	Will Gray	Excel Programming	1	August 24th 06 03:35 AM
Call vs. Run command	Chris McFarland	Excel Programming	1	June 21st 04 04:10 PM

All times are GMT +1. The time now is 09:42 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us