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.