Sparkle
Sparkle

Reputation: 2469

Flat File Import!

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

Answers (1)

Derek Beattie
Derek Beattie

Reputation: 9478

Filehelpers is a nice lib http://www.filehelpers.com/. I can probably dig up some examples.

Upvotes: 4

Related Questions