Re: import multiple text file into cell
From: Steve Kass (skass_at_drew.edu)
Date: 07/31/04
- Next message: mtgoli: "missing value of a field"
- Previous message: Steve Kass: "Re: delete and update operation on linked server"
- In reply to: IT Dep: "import multiple text file into cell"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 31 Jul 2004 01:08:19 -0400
Dan,
Except for your comment about commas, this might help you out:
http://groups.google.com/groups?q=skass+mytexts+tf2
-- Steve Kass
-- Drew University
-- Ref: 5414D02E-C819-4DCA-B553-9DDB2D503DB7
IT Dep wrote:
>Hi,
>
>Still having the same problem (as follows), I had posted it before but
>haven't managed to resolve the issue. Sorry for reposting it.
>
>
>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
>----------------------------------------------------------------------------
>-----
>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
>
>
>
>
>
- Next message: mtgoli: "missing value of a field"
- Previous message: Steve Kass: "Re: delete and update operation on linked server"
- In reply to: IT Dep: "import multiple text file into cell"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
