SQL sentence in ADO object

  • Thread starter Thread starter thread
  • Start date Start date
T

thread

Hi all,
i'm trying to build dynamic objects with VBA,it there a way to place
inside the object the SQL sentence so it will build some temporary query
 
What sort of "objects" are you talking about? Certainly you can use ADO to
run an arbitrary SQL statement using either the Command or Recordset
objects.
 
yes,thanks this is what i needed,its for the option to export data to
excel when changing fields dynamicly

Douglas J. Steele ëúá:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

extract SQL sentence from a query via vba code 1
place a value of SQL sentence inside of variable of vb code 1
Multiselect and ADO filter syntax problem 1
refer to an index field and not to its name 2
String is to short for SQL sentence 2
PowerPoint Powerpoint Slow Animations 2
pulling SQL sentence from a query to a string value 3
is it posible to convert text in a table to a query with vba code 10

Back
Top