i have to design an application to read all text files from a folder and store in sql server 2005.
each file has an average size of 1 MB.
User can search and view all data by User Interface.
I wish to enquirer if it is good practice to store text file content in tables.
text file data is in alphanumeric and continuous format.
Please suggest me how can i do this and is there any other way to do it.