Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 --- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
separate lines in excel | Excel Discussion (Misc queries) | |||
Separate lines in Excel cell | Excel Worksheet Functions | |||
Looking for code to separate one line of text into multiple lines in Excel | Excel Worksheet Functions | |||
Import multiple csv files into current workbook as separate sheets | Excel Programming | |||
Import several txt files into separate sheets within 1 workbook | Excel Programming |