We are using a attendance machine in our organisation for the employee daily attendance, which have lan facility and working on IP: 10.0.0.186
The vendor have us a patch which get data to the machine and generate text file of attendance. Sample attached. Which I called into SQL through following statement.
delete from Emp_DB.dbo.intermediary
Bulk Insert Emp_DB.dbo.intermediary From '\\10.0.0.150\Att\txtfile.
txt' With (FieldTerminator=',', FirstRow=1, rowterminator ='\n')
Is there any way may I get data directly into MS SQL-2005. Through any store procedure or something else. It would help us to avoid manual edit which generally did by the updating person before update.