anyone know how to convert text file into excel file?

miracleplasma · 17th Jun 2004, 04:35 PM

I have problem here.Can anyone tell me or give me a sample code of copying a data from text file to excel file?What I mean is that the number of that value has to be in the column and the row in the excel program based on the value that is in the text file.The souce file has to be text file and then send it over to excel program using Visual basic.In shortcut, how to convert the file format of text into excel. Thanks.

plasma · 18th Jun 2004, 12:39 AM

first convert the text file to a table....

then from excel, insert object..... just try around,.u'll get it

Adrian Wong · 18th Jun 2004, 02:53 AM

I think you can import it using Excel but you must separate the values in the text file by tabs or commas. Give it a shot.

miracleplasma · 18th Jun 2004, 08:26 AM

Quote:

Originally Posted by Adrian Wong

I think you can import it using Excel but you must separate the values in the text file by tabs or commas. Give it a shot.

That is correct.But my problem is that it has to be done using Visual basic where the text file acts as the input file and produce the output in excel program.Thanks for reply.

miracleplasma · 18th Jun 2004, 08:28 AM

Quote:

Originally Posted by plasma

first convert the text file to a table....

then from excel, insert object..... just try around,.u'll get it

How? From text file to a table?I don't really understand.What is the code of the visual basic for convert into the table?Anyway, thanks a lot.

Falcone · 18th Jun 2004, 09:19 AM

I can't remember my visualbasic, in theory u can use visual basic to edit the text file and convert in to the rite format eg .csv file by just adding comma and it can be open by excel then, or u wanna be creative and convert to xml file. Adding a comma in textfile should be piece of cake.

miracleplasma · 18th Jun 2004, 01:52 PM

Quote:

Originally Posted by Falcone

I can't remember my visualbasic, in theory u can use visual basic to edit the text file and convert in to the rite format eg .csv file by just adding comma and it can be open by excel then, or u wanna be creative and convert to xml file. Adding a comma in textfile should be piece of cake.

but the problem is that the text file should not be put with comma.So, what can I do.How do u convert text file to .csv format.Can you please teach me?lastly, the visual basic has to be develop.Thanks for the tips.

Falcone · 18th Jun 2004, 10:01 PM

.csv are text files...just that they are formated in way, using either , or tab as column devider....

17th Jun 2004, 04:35 PM	#1 (permalink)
miracleplasma Just Started Join Date: 27 Dec 2003 Location: Malaysia Posts: 55 Reputation: 0 Rep Power: 0	anyone know how to convert text file into excel file? I have problem here.Can anyone tell me or give me a sample code of copying a data from text file to excel file?What I mean is that the number of that value has to be in the column and the row in the excel program based on the value that is in the text file.The souce file has to be text file and then send it over to excel program using Visual basic.In shortcut, how to convert the file format of text into excel. Thanks.

18th Jun 2004, 02:53 AM	#3 (permalink)
Adrian Wong Da Boss Join Date: 10 Oct 2002 Location: In front of my ASUS F8V notebook! Posts: 32,299 Reputation: 3574 Rep Power: 75	I think you can import it using Excel but you must separate the values in the text file by tabs or commas. Give it a shot. __________________ Dr. Adrian Wong Tech ARP \| Blog @ Tech ARP \| The Free Trade Zone DYKT : The only offshore account I have is at the sand bank? We need PROGRAMMERS and TECHNICAL WRITERS! Contact us if you are a hot shot programmer or technical writer! My items for sale : 50x SD Card \| Memory Stick PRO \| Cyclone Energy Saver \| Seiko SS watch \| Tiger/Carlsberg beer jugs \| Travel Speakers \| Motorola V600 \| Nokia N90 SOLD! \| New Lowepro Mini Trekker AW Other items for sale @ the FTZ : Zalman CNPS9500 LED @ $20 \| Zalman CNPS7700 Cu @ $20 \| Zalman CNPS7000 Cu @ $20 \| Swarovski bracelet watches \| Dell 17" LCD \| Hi-Fi speakers \| English DIVX movies \| HP LaserJet toners! \| Office chairs

18th Jun 2004, 09:19 AM	#6 (permalink)
Falcone Official Mascot Creator Join Date: 18 Dec 2002 Location: Shanghai, See En Posts: 3,348 Reputation: 1878 Rep Power: 28	I can't remember my visualbasic, in theory u can use visual basic to edit the text file and convert in to the rite format eg .csv file by just adding comma and it can be open by excel then, or u wanna be creative and convert to xml file. Adding a comma in textfile should be piece of cake. __________________ I'm a noob, my photos sucks, but if you can live with that... http://www.pumpkinproject.com/ Flickr

18th Jun 2004, 10:01 PM	#8 (permalink)
Falcone Official Mascot Creator Join Date: 18 Dec 2002 Location: Shanghai, See En Posts: 3,348 Reputation: 1878 Rep Power: 28	.csv are text files...just that they are formated in way, using either , or tab as column devider.... __________________ I'm a noob, my photos sucks, but if you can live with that... http://www.pumpkinproject.com/ Flickr

18th Jun 2004, 12:39 AM	#2 (permalink)
plasma Active Join Date: 8 Feb 2004 Location: Penang Posts: 677 Reputation: 58 Rep Power: 6	first convert the text file to a table.... then from excel, insert object..... just try around,.u'll get it