@ScottPletcher: Thank you Scott. I apparently misunderstood you. I assumed you meant that you preferred to generate the loading of records by moving the file to the db...

@ScottPletcher: haha... the above response is for you. That's a dead giveaway that I'm new around here.

@SSCommitted: I would sure love to see an example of what you mentioned. That's exactly what I envisioned but cannot for the life of me find an example...

Well that looks promising. Let me do some reading and see where it leads. I think I may have looked at that once long ago, but shelved it...

Yes Jeff. We are using asp.net 3.5 to present the users/analysts with the tools they require. The data provider uploads files on the 1st of the month. ...

Thank you Jeff... and I hear you. I wish this was the first time a "we don't do that here" has bit me.

And again, I failed to give total...

@MyDoggieJessie: Sorry -- it would be stored as actual character string if that's the way forward

@MyDoggieJessie: text, not binary.

I apologize for not laying the groundwork... so here's the process.

User uploads a file to website application. The site parses the text file and generates insert parameters...

The text file itself.