Reputation: 2469
I would like to import .csv .txt .xml and fixed length files into a mssql database. I would like to validate each files data before the import and map the data to columns in the database after the validation.
Could anyone please advise me of a project or a blog as a starting point? I would like to find a project the allows the uploads off all these file type even if in a fixed format to begin with. Anybody know of a project that could get me off to a good start?
I would appreciate any input or words of advice!
Upvotes: 0
Views: 980
Reputation: 9478
Filehelpers is a nice lib http://www.filehelpers.com/. I can probably dig up some examples.
Upvotes: 4