loop in database

G

God Itself

hi,

i'm newbie in access, so i need some tips.

there are 3 tables in database:
1. the first table is main table (almost 2 milion of rows and 5 columns)
2. second one is only with labels (30 rows and 2 columns: NAMECODE and NAME)
3. third table is a result of querry creating this table (Q-create)

there are also several querries, therein six querries that must be exported
into xls file

so - i have to automate following process:
a. write loop in VBA which
- insert cryterium in Q-create (column 'NAMECODE') from second table
(from column NAME)
- run Q create
- run rest of all querries
b and export data from six querries into excel (into six sheets)

regards
 

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

Top