Wow, that's a lot to take in.

My idea would be to have vb open the document and then loop through each line. Inside the loop create a select case statement that would catch any of the details that you listed above (the tab, the hard returns, etc) and then have each case save the result from the line into a variable so you can pass a full record to the database.

Help any?