Results 1 to 7 of 7
  1. #1
    Join Date
    Apr 2002
    Posts
    3

    Unanswered: Change CSV file to XLS

    Hi,

    I want to automate my performance monitoring Reports(sql2000). So I need to import performance monitor output log file .CSV to a table. I feel converting this .CSV to .XLS is good way to importing the log thru DTS. Is there any command/ script to change the file type .CSV to .XLS, so that i can include this one into DTS Step.

    thanks

  2. #2
    Join Date
    Feb 2003
    Location
    Brisbane, Australia
    Posts
    110

    Re: Change CSV file to XLS

    Originally posted by krishna
    Hi,

    I want to automate my performance monitoring Reports(sql2000). So I need to import performance monitor output log file .CSV to a table. I feel converting this .CSV to .XLS is good way to importing the log thru DTS. Is there any command/ script to change the file type .CSV to .XLS, so that i can include this one into DTS Step.

    thanks

    Why can you not import the csv file? What advantages does importing a .XLS file provide?

  3. #3
    Join Date
    Apr 2002
    Posts
    3
    because, it is easy to import excel file than csv format.

  4. #4
    Join Date
    Feb 2003
    Location
    Brisbane, Australia
    Posts
    110
    DTS can handle .CSV files just as easy as it can handle .XLS files that is why I was askng for advantages. Sorry I couldn't help.

    Originally posted by krishna
    because, it is easy to import excel file than csv format.

  5. #5
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    I don't see any issues in handling .CSV or .XLS by Excel and SQL server DTS.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  6. #6
    Join Date
    Apr 2002
    Posts
    3
    what datasouce i should use ? Microsoft Text-Treiber(*.txt,*.csv)?
    If i use this one as datasource for to import CSV file into table it is not converting datetime column. I was thinking of using Microsoft Excel for the datasource thats why i asked about converting csv to xls

  7. #7
    Join Date
    Jul 2013
    Posts
    3

    use this converter

    Use this online CSV to XLS Converter because its a very secure cloud API so i would recommend you to use this one.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •