Multiple SQL statements off one ODBC Connection

**Andy2010** · 12-31-2009, 08:09 AM

Hello,

I was wondering if it was possible to have more than one SQL statement off one ODBC Connection?

And if the answer is 'Yes' how?

Many Thanks

Andy

**romperstomper** · 12-31-2009, 08:16 AM

Do you mean in code? If so, yes - just keep the connection open between opening different recordsets.

**Andy2010** · 12-31-2009, 08:47 AM

Thanks, how would that be displayed? And could it be outputted into different cells?

An example would be great!

Many Thanks

**romperstomper** · 12-31-2009, 08:52 AM

It's not entirely clear to me what you are after, but here's some code to output data from an Access database query into a worksheet:

Please Login or Register  to view this content.

Multiple SQL statements off one ODBC Connection

LinkBack

Thread Tools

Rate This Thread

Display

Multiple SQL statements off one ODBC Connection

Re: Multiple SQL statements off one ODBC Connection

Re: Multiple SQL statements off one ODBC Connection

Re: Multiple SQL statements off one ODBC Connection

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions