export access data to excel and reformat

[George Applegate]

I have a data base that looks like this in access:

emp# Date Time In or out

Obviously multiple records for each employee, on each date

I would like to somehow import the data into excel though, so it looks
like this:

emp# date In Tim 1 Out tim 1 In tim 2 Out tim 2 In tim3 Out tim 3

In other words, when the date comes into excel from access, how can I
get the multiple ins and outs for a day on the same line if it's the
same date??? Do I have to write some sort of visual basic program, or
is there an easy way to do this?

I'd appreciate all suggestions

thanks,
ga

George Applegate
(e-mail address removed)

 

[Larry Daugherty]

Any programming required will be in Excel (even though you may be able
to execute it from Access). Therefore, I'd post your question into
one of the Excel programming groups.

HTH