|
|
Posted by stephen on 08/16/07 08:48
On Aug 16, 5:35 am, sachin shah <sachin28...@gmail.com> 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
Navigation:
[Reply to this message]
|