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.

thanksOriginally 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?|||because, it is easy to import excel file than csv format.|||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.|||I don't see any issues in handling .CSV or .XLS by Excel and SQL server DTS.|||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

change acceptable filesize of files to be placed in the portal

Nice thing of the reporting services portal is the option to upload
different type of files like xls and pdf.
I was trying to upload a pdf of 5 megs but the portal didn't accept it.
Is it possible to change the maximum acceptable filesize?Do you realize that RS anything deployed into a database. Nothing is stored
as a file. RS is not really designed to be used as a document storage
system. Although as you discovered you can do this (I have done it for some
word documents).
I am not aware of any parameter to change in this regard (changing the max
file size).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"nickismyname" <j.koopmans@.novio.nl> wrote in message
news:1166110729.330622.237020@.16g2000cwy.googlegroups.com...
> Nice thing of the reporting services portal is the option to upload
> different type of files like xls and pdf.
> I was trying to upload a pdf of 5 megs but the portal didn't accept it.
> Is it possible to change the maximum acceptable filesize?
>