Best way to execute Access SQL queries in VBA and return results in new saved tables

[colmkav]

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

[Deanna Earley]

Post by colmkav
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?

How is this different to the question you asked 18 hours and 15 minutes
earlier?

[colmkav]

Post by Deanna Earley

Post by colmkav
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?

How is this different to the question you asked 18 hours and 15 minutes
earlier?
--
i-Catcher Development Teamhttp://www.icode.co.uk/icatcher/
iCode Systems
(Replies direct to my email address will be ignored.
Please reply to the group.)

sorry, I meant to post something different. How do I delete this post?