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

M

Max

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

Max

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.
 

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