software

Howdy, folks...

Here's a sample of the payroll info we get. How can I import it into excel
in an orderly way? All I need is the name and the in and out times. How do
I get Excel to import only the data I need?

Jojo, Sparks 123456 131204 88888888 700 101092770
ID IN DEP Cus Fun ACTIVITY OUT ID IN DEP
Cus Fun ACTIVITY OUT TOTALS
Mon 03/20 645a*U 1132a M 1200p*S
341p 8.50 8.50
Tue 03/21 649a*U 1124a M 1152a*S
330p 8.20 16.70
Wed 03/22 653a*U 1129a M 1137a*S
341p 8.30 25.00
Thu 03/23 647a*U 1135a M 1202p*S
341p 8.40 33.40
Fri 03/24 653a*U 1141a M 1155a*S
330p 8.10 41.50*U
Sat 03/25 Unscheduled

Sun 03/26 UnscheduledAcct:131204 88888888 700
Regular: 40.00 OverTime: 1.50 TOTALS:
41.50
Can you request the payroll report as a delimited text file, this would make
it much easier for you to import.

If you click FILE from the menu and select OPEN and change the file type to
text file, the Text File Import Wizard automatically opens. The wizard lets
you pick which row to start the import on, what the delimiter is and what
columns to import.
--
Kevin Backmannquot;Jaybirdquot; wrote:

gt; Howdy, folks...
gt;
gt; Here's a sample of the payroll info we get. How can I import it into excel
gt; in an orderly way? All I need is the name and the in and out times. How do
gt; I get Excel to import only the data I need?
gt;
gt; Jojo, Sparks 123456 131204 88888888 700 101092770
gt; ID IN DEP Cus Fun ACTIVITY OUT ID IN DEP
gt; Cus Fun ACTIVITY OUT TOTALS
gt; Mon 03/20 645a*U 1132a M 1200p*S
gt; 341p 8.50 8.50
gt; Tue 03/21 649a*U 1124a M 1152a*S
gt; 330p 8.20 16.70
gt; Wed 03/22 653a*U 1129a M 1137a*S
gt; 341p 8.30 25.00
gt; Thu 03/23 647a*U 1135a M 1202p*S
gt; 341p 8.40 33.40
gt; Fri 03/24 653a*U 1141a M 1155a*S
gt; 330p 8.10 41.50*U
gt; Sat 03/25 Unscheduled
gt;
gt; Sun 03/26 Unscheduled
gt;
gt;
gt; Acct:131204 88888888 700
gt; Regular: 40.00 OverTime: 1.50 TOTALS:
gt; 41.50
gt;
gt;

Unfortunately, payroll is even less knowledgable about the formatting than I.
Getting them to send it in another format may prove to be a challenge. I am
familiar with the Import wizard, but I can't seem to use it to organize the
data in a useful way. I'd like to be able to put it in an Access database
once I separate out the useful information.

Jaybird

quot;Kevin Bquot; wrote:

gt; Can you request the payroll report as a delimited text file, this would make
gt; it much easier for you to import.
gt;
gt; If you click FILE from the menu and select OPEN and change the file type to
gt; text file, the Text File Import Wizard automatically opens. The wizard lets
gt; you pick which row to start the import on, what the delimiter is and what
gt; columns to import.
gt; --
gt; Kevin Backmann
gt;
gt;
gt; quot;Jaybirdquot; wrote:
gt;
gt; gt; Howdy, folks...
gt; gt;
gt; gt; Here's a sample of the payroll info we get. How can I import it into excel
gt; gt; in an orderly way? All I need is the name and the in and out times. How do
gt; gt; I get Excel to import only the data I need?
gt; gt;
gt; gt; Jojo, Sparks 123456 131204 88888888 700 101092770
gt; gt; ID IN DEP Cus Fun ACTIVITY OUT ID IN DEP
gt; gt; Cus Fun ACTIVITY OUT TOTALS
gt; gt; Mon 03/20 645a*U 1132a M 1200p*S
gt; gt; 341p 8.50 8.50
gt; gt; Tue 03/21 649a*U 1124a M 1152a*S
gt; gt; 330p 8.20 16.70
gt; gt; Wed 03/22 653a*U 1129a M 1137a*S
gt; gt; 341p 8.30 25.00
gt; gt; Thu 03/23 647a*U 1135a M 1202p*S
gt; gt; 341p 8.40 33.40
gt; gt; Fri 03/24 653a*U 1141a M 1155a*S
gt; gt; 330p 8.10 41.50*U
gt; gt; Sat 03/25 Unscheduled
gt; gt;
gt; gt; Sun 03/26 Unscheduled
gt; gt;
gt; gt;
gt; gt; Acct:131204 88888888 700
gt; gt; Regular: 40.00 OverTime: 1.50 TOTALS:
gt; gt; 41.50
gt; gt;
gt; gt;