Import table into Excel with lines sliced into separate sheets by UID
 

I've got a 5 col table in Access (sample below) which I'm trying to import
into a single excel book with lines filtered by UIDs into individual sheets
(with the UIDs as the sheetnames)

Source table in Access:
F1 TTime TDate Tcode TAmt UID
1 15:08 12-Sep-06 1 500 I706
2 22:33 26-Sep-06 81 50 8511
3 13:32 24-Sep-06 81 100 8511
3 20:15 09-Sep-06 81 200 I001
4 16:08 11-Sep-06 1 1100 I706
etc

Desired import in Excel

In sheet: I706
F1 TTime TDate Tcode TAmt UID
1 15:08 12-Sep-06 1 500 I706
4 16:08 11-Sep-06 1 1100 I706

In sheet: 8511
F1 TTime TDate Tcode TAmt UID
2 22:33 26-Sep-06 81 50 8511
3 13:32 24-Sep-06 81 100 8511

In sheet: I001
F1 TTime TDate Tcode TAmt UID
3 20:15 09-Sep-06 81 200 I001

Is there a sub which I can trigger from within Excel to do the above job ?

The problem is that the source table contains in excess of 300K rows,
although individually, each UID's lines will be less than the sheet limit of
65K

The Access file is named: Txn Sep06.mdb and the table is named: TWDL

Any insights appreciated. Thanks.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Import table into Excel with lines sliced into separate sheets by UID
 

Could I settle for a sub to direct inport the 300k Access table into Excel
sliced into as many sheets as required, viz into 5 sheets ? Doesn't have to
be sliced by UID. Any thoughts appreciated. Thanks.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Max" wrote in message
...
I've got a 5 col table in Access (sample below) which I'm trying to import
into a single excel book with lines filtered by UIDs into individual
sheets (with the UIDs as the sheetnames)

Source table in Access:
F1 TTime TDate Tcode TAmt UID
1 15:08 12-Sep-06 1 500 I706
2 22:33 26-Sep-06 81 50 8511
3 13:32 24-Sep-06 81 100 8511
3 20:15 09-Sep-06 81 200 I001
4 16:08 11-Sep-06 1 1100 I706
etc

Desired import in Excel

In sheet: I706
F1 TTime TDate Tcode TAmt UID
1 15:08 12-Sep-06 1 500 I706
4 16:08 11-Sep-06 1 1100 I706

In sheet: 8511
F1 TTime TDate Tcode TAmt UID
2 22:33 26-Sep-06 81 50 8511
3 13:32 24-Sep-06 81 100 8511

In sheet: I001
F1 TTime TDate Tcode TAmt UID
3 20:15 09-Sep-06 81 200 I001

Is there a sub which I can trigger from within Excel to do the above job ?

The problem is that the source table contains in excess of 300K rows,
although individually, each UID's lines will be less than the sheet limit
of 65K

The Access file is named: Txn Sep06.mdb and the table is named: TWDL

Any insights appreciated. Thanks.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---