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
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