Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.basic.visual.misc > #1197
| From | colmkav <colmjkav@yahoo.co.uk> |
|---|---|
| Newsgroups | comp.lang.basic.visual.misc |
| Subject | Best way to execute Access SQL queries in VBA and return results in new saved tables |
| Date | 2012-06-08 00:41 -0700 |
| Organization | http://groups.google.com |
| Message-ID | <5b3e8dc6-fcc7-4aa4-a64a-812bca3cd852@e20g2000vbm.googlegroups.com> (permalink) |
What is the best way to approach my problem: I want to run a series of Access SQL queries (currently 13) eg qryRule01 and store the results in tables of the similar name eg tblRule01. I also wish to use a date parameter which will usually be the previous days date. How best is it to do this? Currently the queries run fine on themselves but when I try to use VBA to run the queries and store the results in a new table using “SELECT * INTO…” I get overflow errors. What’s the neatest/best way to do this? Colm
Back to comp.lang.basic.visual.misc | Previous | Next — Next in thread | Find similar
Best way to execute Access SQL queries in VBA and return results in new saved tables colmkav <colmjkav@yahoo.co.uk> - 2012-06-08 00:41 -0700
Re: Best way to execute Access SQL queries in VBA and return results in new saved tables Deanna Earley <dee.earley@icode.co.uk> - 2012-06-08 08:50 +0100
Re: Best way to execute Access SQL queries in VBA and return results in new saved tables colmkav <colmjkav@yahoo.co.uk> - 2012-06-08 00:58 -0700
csiph-web