data transfer from .csv file to sql server 2000

Hi All,

1. i want to transfer the .csv file data into sql server table, i
tried with the DTS but while creating DSN it not prompt to attech
the .csv file. give me the proper steps to perform the data
transfer...

2. i want result of my query into excel or text file by using the sql
query( like Select * from employee where emp_salary>10000 to 'c:
\emp.xls).i know the other way right click into query analyzer window
and select option result to file, but want the result by using SQL
query.....

>From Sachin Shah

Re: data transfer from .csv file to sql server 2000

On Aug 16, 5:35 am, sachin shah wrote:
> Hi All,
>
> 1. i want to transfer the .csv file data into sql server table, i
> tried with the DTS but while creating DSN it not prompt to attech
> the .csv file. give me the proper steps to perform the data
> transfer...
>

Not sure what DSN is but if you run the Import/Export utility you can
select Text File as the data source. Then select the text file you
want to import and follow the steps to select the table to import
into, column mappings, etc.


> 2. i want result of my query into excel or text file by using the sql
> query( like Select * from employee where emp_salary>10000 to 'c:
> \emp.xls).i know the other way right click into query analyzer window
> and select option result to file, but want the result by using SQL
> query.....

You could run the query from the command line using bcp or osql
(isql?) and specify an output file to contain the results.

>
> >From Sachin Shah

Re: data transfer from .csv file to sql server 2000

On Aug 16, 1:48 pm, stephen wrote:
> On Aug 16, 5:35 am, sachin shah wrote:
>
> > Hi All,
>
> > 1. i want to transfer the .csv file data into sql server table, i
> > tried with the DTS but while creating DSN it not prompt to attech
> > the .csv file. give me the proper steps to perform the data
> > transfer...
>
> Not sure what DSN is but if you run the Import/Export utility you can
> select Text File as the data source. Then select the text file you
> want to import and follow the steps to select the table to import
> into, column mappings, etc.
>
> > 2. i want result of my query into excel or text file by using the sql
> > query( like Select * from employee where emp_salary>10000 to 'c:
> > \emp.xls).i know the other way right click into query analyzer window
> > and select option result to file, but want the result by using SQL
> > query.....
>
> You could run the query from the command line using bcp or osql
> (isql?) and specify an output file to contain the results.
>
>
>
>
>
> > >From Sachin Shah- Hide quoted text -
>
> - Show quoted text -

====

my first query is solved thanxs...

but second one is i don't understand...