How to convert txt into excel files

[jmlsauls]

Hey guys

i have to create a drag an drop program that takes a text file an coverts it into an excel file...iv got the drag an drop sorted but how do i convert the txt into an excel file and distinguesh what the column headings will be etc

please im kinda new to vb, would appreciate some help
thanx

[talkro]

it al depends on the structure of you text file.
You have to give a specific structure to your text and then read accordingly. Each item read is going to be added to an excel file that you will create through your vb application. But first define the structure of your text file. and read the information inside.

[Hack]

Are you using VB.NET or VB6?

You have this thread in three sections. I've already deleted the one in C#, and either this thread or the one in Visual Basic 6 and Earlier will also be removed. I just need to know which one.

Please do not post the same question in multiple sections.

[jmlsauls]

thanx...but does any1 perhaps have a code sample for me on how to do this exactly?? everywhere else on the web i only found how to convert from excel to pdf or word to pdf etc

[max_carpenter]

there is a tool already in excel called 'text to columns'

[SonicBoomAu]

Hi,

Did you happen to do a search within this forum for "Text convert excel", it comes up with 140 threads........

This is one thread picked a random.
http://www.vbforums.com/showthread.p...+convert+excel

This will at least give you a starting point.

Hope this helps

[RobDog888]

Another option ...
http://www.vbforums.com/showthread.php?t=408487