Posted by sachin shah on 08/16/07 04:35

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

• Next in forum: month name from the sql query
• Prev in forum: Re: standard and easy way to do schema design
• Thread view: data transfer from .csv file to sql server 2000

[Reply to this message]