data transfer from .csv file to sql server 2000

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • sachin shah
    #1

    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>1000 0 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
    Tags: None
    • stephen
      #2
      Re: data transfer from .csv file to sql server 2000

      On Aug 16, 5:35 am, sachin shah <sachin28...@gm ail.comwrote:
      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>1000 0 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

        Comment

        • sachin shah
          #3
          Re: data transfer from .csv file to sql server 2000

          On Aug 16, 1:48 pm, stephen <m0604...@googl email.comwrote:
          On Aug 16, 5:35 am, sachin shah <sachin28...@gm ail.comwrote:
          >
          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>1000 0 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...

            Comment

            Previous template Next
            Working...