| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting to SQL Server without ODBC from VBA
What is slow? It may be the way you're coding. Did you mean to pass a
variable to your SQL? Absolutely. -- Regards, Dave Patrick ....Please no email replies - reply in newsgroup. Microsoft Certified Professional Microsoft MVP [Windows] http://www.microsoft.com/protect "Goofy" wrote: | Actually Dave, it did work, it was me that was in error. However, it does | not really seem to be much faster, but then we are talking vba here so that | is probably the bottleneck. | | I know that on ODBC, you cant use named parameters, but are you able to do | this using OLEDB ? | | Cheers for your help. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Getting to SQL Server without ODBC from VBA
OK, well to put this in context, I am generating about 7,000 records in one
hit. This takes approximately 90 seconds. "Dave Patrick" wrote in message ... What is slow? It may be the way you're coding. Did you mean to pass a variable to your SQL? Absolutely. -- Regards, Dave Patrick ....Please no email replies - reply in newsgroup. Microsoft Certified Professional Microsoft MVP [Windows] http://www.microsoft.com/protect "Goofy" wrote: | Actually Dave, it did work, it was me that was in error. However, it does | not really seem to be much faster, but then we are talking vba here so that | is probably the bottleneck. | | I know that on ODBC, you cant use named parameters, but are you able to do | this using OLEDB ? | | Cheers for your help. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Getting to SQL Server without ODBC from VBA
Still doesn't help. Can you post the code?
-- Regards, Dave Patrick ....Please no email replies - reply in newsgroup. Microsoft Certified Professional Microsoft MVP [Windows] http://www.microsoft.com/protect "Goofy" wrote: | OK, well to put this in context, I am generating about 7,000 records in one | hit. This takes approximately 90 seconds. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Getting to SQL Server without ODBC from VBA
Ive made improvement now, thanks for your reply.
"Dave Patrick" wrote in message ... Still doesn't help. Can you post the code? -- Regards, Dave Patrick ....Please no email replies - reply in newsgroup. Microsoft Certified Professional Microsoft MVP [Windows] http://www.microsoft.com/protect "Goofy" wrote: | OK, well to put this in context, I am generating about 7,000 records in one | hit. This takes approximately 90 seconds. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing ODBC server (MySQL) | Excel Worksheet Functions | |||
| Server swap & ODBC DNS refreshing | Excel Programming | |||
| SQL Server ODBC Error | Excel Discussion (Misc queries) | |||
| ODBC connection for insert into SQL Server | Excel Programming | |||
| accessing SQL server from Excel/VBA (instead of ODBC) | Excel Programming | |||
Hybrid Mode
