Excel Reading in background Process (i.e using windows services)

sreenivas rao

Jun 18 2009 5:12 AM

2.2k

I have a Excel file that is not in a table format
i want to read the required data from that excel file in the background (using windows service)and store it into sql database
Excel data would be like this
151601 ,151602 are the two records
i want to read some of the data from each recrod
this is sample excel file.this excel might have thousands of records like this

151601		464855166	xxxxxxx, xxxxxx		10/2/1976	6/1/2009 9:18 AM		xxxxxxx,xxxxxxx
					xxxxx		xxxxxxxxx
	xxxxxxxxxx:	xxxxxxxxxx					xxxxxxxxx	31481
	xxxxxxxxx	xxxxxxxxxx					xxxxxxxxx	xxxxxxxxx
	xxxxxxxx	xxxxxxxxxx					xxxxxxxxx
xxxxx				6/1/2009 at 09:34 AM (DMP)	85025			0.00	21.72
xxxxx				6/1/2009 at 10:04 AM (DMP)	85652			0.00	6.50
xxxxxxxxxxxxxL*				6/1/2009 at 09:57 AM (DMP)	80053
151602		456840093	xxxxxxxxx,xxxxxxxxxx		11/13/1948	6/1/2009 9:20 AM		xxxxxxxxxx,xxxxxxxxx
	xxxxxxxxxx:	xxxxxxxxxx					xxxxxxxxx	xxxxxxxxx
	xxxxxxxxx	xxxxxxxxxx					xxxxxxxxx	xxxxxxxxx
	xxxxxxxxx	xxxxxxxxxx					xxxxxxxxx
xxxxxxxxxxxxxx*				6/1/2009 at 10:00 AM (DMP)	80053