[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 276
  • Last Modified:

vb.net 2005 convert text file to excel file

I have this in a text.txt file:
,02/14,11:58P,00:00:30,460,9,6053300032,ARX024,097
,02/15,12:23,00:01:03,264,9,6053361616,ARX023,097
,02/15,12:35,00:00:49,X101,005,*4792000355*4426301,300,097,4792000355,4426301,COLLINS,JOSHUA,
,02/15,01:08,00:01:01,300,9,18008005161,RX123,097

And I want to convert it to .xls.  Now I can convert the extension easy enough but it is not a valid excel document.  
Thanks
0
bergertime
Asked:
bergertime
2 Solutions
 
jpaulinoCommented:
You can change the extension to CSV and it will open in excel.
If you need also to split by the commas you can change the , to ;
0
 
CodeCruiserCommented:
If you need to convert to xls file, you can open it in excel and use save as. Or use Office API to create the Excel file yourself.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now