|
Home > Archive > MS SQL Server Clients > March 2005 > Text file in text column
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Text file in text column
|
|
| Rogers 2005-03-30, 7:04 pm |
| Can any one let me know like I wanna save the text file into text column and
see the data through select statement.
| |
| David Gugick 2005-03-30, 7:04 pm |
| "Rogers" <Rogers@discussions.microsoft.com> wrote in message
news:8C6B4AB0-4A86-492F-8499- 4AF52479C290@microso
ft.com...
> Can any one let me know like I wanna save the text file into text column
> and > see the data through select statement.
You can create a stored procedure that uses a text or ntext parameter and
inserts into the table. If you can't easily paste the text into a tool like
Query Analyzer to execute the procedure, you can use some client application
code in .net or classic VB to open the text file, establish a connection
with the server, and execute the procedure.
You may also be able to use the DTS Import wizard to process the file as a
single row, single column file and insert into the table.
--
David Gugick
Imceda Software
www.imceda.com
| |
| Rogers 2005-03-30, 7:04 pm |
|
First of all thanks for your reply but now there is one question like let's
assume we have saved the file in text column now I want to see the data so
can I see like that
select textfildname from tablename ?
thanks
"David Gugick" wrote:
> "Rogers" <Rogers@discussions.microsoft.com> wrote in message
> news:8C6B4AB0-4A86-492F-8499- 4AF52479C290@microso
ft.com...
>
> You can create a stored procedure that uses a text or ntext parameter and
> inserts into the table. If you can't easily paste the text into a tool like
> Query Analyzer to execute the procedure, you can use some client application
> code in .net or classic VB to open the text file, establish a connection
> with the server, and execute the procedure.
>
> You may also be able to use the DTS Import wizard to process the file as a
> single row, single column file and insert into the table.
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>
>
>
| |
| David Gugick 2005-03-30, 7:04 pm |
| That SQL will work.
--
David Gugick
Imceda Software
www.imceda.com
"Rogers" <Rogers@discussions.microsoft.com> wrote in message
news:26AEAA01-79D9-4835-96EF- C0EFAB0A5867@microso
ft.com...[color=darkred]
>
> First of all thanks for your reply but now there is one question like
> let's
> assume we have saved the file in text column now I want to see the data so
> can I see like that
>
>
> select textfildname from tablename ?
>
> thanks
>
>
> "David Gugick" wrote:
>
|
|
|
|
|