Got more questions? Find advice on: ASP | XML | Regular Expressions | Windows
in Search
Welcome to SqlAdvice Sign in | Join | Help

how to insert a large text file into table

Last post 05-05-2009, 5:40 PM by Jayaram Krishnaswamy. 1 replies.
Sort Posts: Previous Next
  •  04-09-2008, 1:27 PM 41237

    how to insert a large text file into table

    my project is a news website. i want to store  news articles in the db so i can retrieve it later and display on the website. the articles are provided in word format from the author. any ideas?

     

    Thanks 

  •  05-05-2009, 5:40 PM 52676 in reply to 41237

    Re: how to insert a large text file into table

    You can use SQL Server 2008 and use the new feature.

     Here is an abstract of an article I am writing:

    Among the type of data that exists in corporate databases today, unstructured data forms a substantial part.  The unstructered data takes different forms, emails, word documetns, videos, music files etc. Also most of the times this data is persisted outside a relational database in files, folders, etc. This type of data because of its distributed nature make it much more diffcult to handle. Assuming that this is stroed in a structured format streaming it out for end use can result in reduced performance. The new capability in SQL Server 2008 can support accessing these by a) Storing File Stream data as varbinary, large objects (BLOBS), b)extending TSQL to insert, update, query and search these objects, and c)Windows 32 file system providing streaming capabiity.

    If you are new to SQL Server 2008, you may access my article to find how you may install one,

    http://hodentek.blogspot.com and search for SQL Server 2008 therein.

    Depending on the amount of information you may also use MS Access 2007 as in,

    http://aspalliance.com/1138_Working_with_Attachment_data_type_in_Microsoft_Access_2007

View as RSS news feed in XML