CSV file into Excel Sheet
-
I need to convert CSV file into an Excel Sheet. Can I have suggesstions or article where can I get the information. Thanks in advance Warm Regards, KKR
Assuming through code, just use the Excel COM object and tell it to open the csv file. Then tell it to save as Excel file.
-
I need to convert CSV file into an Excel Sheet. Can I have suggesstions or article where can I get the information. Thanks in advance Warm Regards, KKR
There are two ways: 1.Using ODBC Excel driver which is available on all Windows PC's even without M$ Office installed, neither on your nor your user's PC. For an example see this: http://www.codeproject.com/database/excel_odbc_write.asp[^] 2.Using Excel automation, requires Office both on you and your user's PC See Adam's message above, and MSDN for Office automation. Peter Molnar