Interface file in Excel file

Interface file in Excel file

Cancelled

Job Description

Input data in SQL server table. Data to be converted to excel file.
The input table would have
1. Employee number
2. Date of attendance
3. Time in
4. Mode (start, end, break in/out)

The above format to be converted to excel file in the following format in a single row
Employee number, Date, time in, time out, date of time in, date of time out

For eg., the input table will be in the below format

1001 20120213 070100 1
1001 20120213 180000 2

The output data to be in the below format

1001 13/02/2013 07:00:01 18:00:00
For night shift 1001 13/02/2013 19:00:00 07:00:00 13/02/2013 14/02/2013

---
Skills: microsoft-sql-server, visual-basic