|
|
Posted by sachin shah on 08/16/07 09:16
On Aug 16, 1:48 pm, stephen <m0604...@googlemail.com> wrote:
> 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- Hide quoted text -
>
> - Show quoted text -
====
my first query is solved thanxs...
but second one is i don't understand...
Navigation:
[Reply to this message]
|