September 8, 2006 at 12:28 pm
I know this has been beaten before and I do know how to import simple text files however does anyone have an idea how to import something like this; there are over 250 names in this text file this is just one of many.
Thanks Marty
Punch Detail Page 0001
08/28/2006 -> 09/02/2006 09/07/2006 11:09a
All accounts, all classes, all Timeclock groups
==================================================================================================================================
0003000052 Last,First Middle 001821 NC-Full Time
==================================================================================================================================
Last,First Middle 0003000052 001821
ID IN DEPT ACTIVITY OUT ID IN DEPT ACTIVITY OUT TOTALS
Mon 08/28 651a 1155a M 1230p*L 333p 8.00 8.00
Tue 08/29 657a 1155a M 1230p*L 431p*L 9.00 17.00
Wed 08/30 654a 1155a M 1233p*L 330p 8.00 25.00
Thu 08/31 653a 1155a M 1233p*L 439p*L 9.00 34.00
Fri 09/01 646a 1156a M 1230p*L 330p 8.00 42.00
Sat 09/02 806a*U 1200p 4.00 46.00
Sun 09/03 Unscheduled
- Audit Suppressed -
Acct:001821
REG: 40.00 OVERTIME: 6.00
----------------------------------------------------------------------------------------------------------------------------------
Employee totals:
Acct:001821 REG: 40.00 OVERTIME: 6.00
Totals: REG: 40.00 OVERTIME: 6.00
September 11, 2006 at 8:00 am
This was removed by the editor as SPAM
September 11, 2006 at 8:06 am
Haven't you looked at DTS or BULK INSERT?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply