Member Avatar for Tekito

Recently I was trying to execute a "SELECT...INTO" query (for an Access db) w/ VB in an Excel macro. Kept getting an error message, so I changed it to just a SELECT query and got "Cannot execute a select query." So is it impossible to execute select queries in VB-excel?

Edit: this is using the command:

set qdf = db.createquerydef("", qrystr)
qdf.execute
  • 1 Contributor
  • 1 Reply
  • 61 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by Tekito
Member Avatar for Tekito

Nevermind, I think I figured it out now.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.