read dat, write Excel

[stealthregal]

Hello,

I am brand new to Visual Basic and it has been a few years since I last did any programming (C++). Right now I would like to create a program that can read in a series of numbers from a dat file and then dump them into Excel. I have a basic idea on what I want to do, but am looking for some tutorials or help documents to get me started. If anyone has any suggestions, I would appreciate it.

 

[stealthregal]

I just wanted to add that right now I can open the file up in my program and presently am dumping it to a big text box. The data is coming in just fine, now I need to figure out how to write it out to Excel.

 

[JuggaloBrotha]

One of the file types that work with Excel very well is the Comma Delimited (CSV) file. All you would need to do is split the data into whatever sections then simply write a text file with the .csv extension and split the pieces of data by a comma.

Although, this doesn't work if the data contains comma's itself.