title: Read from an existing text file(.txt) in sql server 2005
body: <p>My gps device writes its data to a text file in my server. Now i want sql server to read it and store values in a table. How to get started with this kind of a scenario? Any suggestion.</p>
  
  <p><strong>EDIT:</strong>
  Consider it is an existing file with 10 rows and i have already imported it. Now the file gets updated with new 10 rows. How to import the new rows to sql server? </p>