On Aug 16, 5:35 am, sachin shah <sachin28...@gmail.comwrote:
Quote:
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.
Quote:
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.
