|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
|
|
#1
July 14th, 2004, 03:09 AM
|
|||
|
|||
Split and export table by cases
Hallo I have table tblFinalOut in MS Access. I would like split and export this table into several MS Excel files by cases (column with name MEM). MEM is number code with text format (some codes begins with zero). Example of table tblFinalOut:
---------- ID MEM MEM_Name ... ... 100 0100 Prague ... ... 200 0100 Prague ... ... 300 0200 London ... ... 400 0200 London ... ... 500 0300 Paris ... ... 600 0100 Prague ... ... I would like split and export this table tblFinalOut into Excel files (by MEM cases) this way file 1: ID MEM MEM_Name ... ... 100 0100 Prague ... ... 200 0100 Prague ... ... 600 0100 Prague ... ... file 2: 300 0200 London ... ... 400 0200 London ... ... file 3: 500 0300 Paris ... ... How can I do this? Table tblFinalOut is too large nad is not possible to do this manualy. Thanks Matous matous_cervenka@kb.cz
|
|
#2
July 15th, 2004, 09:19 AM
|
|||
|
|||
|
The simplest way is to create a Parameter query which asks you for input. Next: separate queries based on each or a combination your criteria.
Depeding on the frequency of utilization, macros and from there it's VBA coding.
|
|
| Viewing: Dev Articles Community Forums > Databases > Microsoft Access Development > Split and export table by cases |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
