Importing textfile into a cell

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: IT Dep (it_at_isslimREMOVE_TO_REPLYited.co.uk)
Date: 07/29/04 

Date: Thu, 29 Jul 2004 16:21:22 +0100

Hi

I am trying to import some text files into MS SQL 2000. I want to import
them into a table with the first column being the filename (excluding the
extension) and the second colunm being the contents of the textfile, I want
the entire textifle to fit into the one cell (ignoring any commas, etc).
Example:

Filename | Contents of the textfile
----------------------------------------------------------------------------
1 | This is the contents of the first file
2 | And the contents of the 2nd file, complete with commas!
Test | And another textfile
File | Some more text from a texfile......

Thanks in advance

Dan

Relevant Pages

  • Text import using DTS?
    ... I am trying to import some text files into MS SQL 2000. ... them into a table with the first column being the filename (excluding the ... Dan ...
    (microsoft.public.sqlserver.dts)
  • Import Multiple text Files
    ... I am trying to import some text files into MS SQL 2000. ... them into a table with the first column being the filename (excluding the ... Dan ...
    (microsoft.public.sqlserver.programming)
  • Import Multiline Text into cell
    ... I am trying to import some text files into MS SQL 2000. ... them into a table with the first column being the filename (excluding the ... Dan ...
    (microsoft.public.sqlserver.odbc)
  • Re: Query a table w/o using column names?`
    ... Are you ready to upgrade to SQL Server? ... So for instance, the first column in the linked sheet might be called for one person, for another person, and for still another. ... I use it to dynamically build SQL statements, and from a purely functional standpoint, it works. ...
    (microsoft.public.access.queries)
  • Re: foreign key references only part of composite PK - table scan issue
    ... part of a composite key. ... a table scan because you join only against the first column in the PK. ... You could just as well get a table scan if you add a second column as ... Links for SQL Server Books Online: ...
    (comp.databases.ms-sqlserver)