Convert XLS into Txt

reubenfoo · #1 (**permalink**) 11-25-2008, 8:10 PM

Hi all,

may i ask how do I convert an Excel file(.xls) into a text file(.txt) using VB.NET.

Does anyone have the coding for this?

thanks a million!

cjard · #2 (**permalink**) 11-25-2008, 8:19 PM

That's like saying "how do i convert an mp3 into a jpeg?" You'll need to be more specific about the layout of both files.

Also your question has little to do with Visual Studio itself (the environment you write programs in) so this is probably the wrong forum

reubenfoo · #3 (**permalink**) 11-25-2008, 8:41 PM

hm.. i would say. the excel data would be extracted from a database into like a gridview format. from there, it should be converted into a txt format with the use of delimiters to end a line.

cjard · #4 (**permalink**) 11-25-2008, 8:47 PM

you can use the automation (loading excel into memory as an object and using it programmatically) to convert the file to csv..

..or you can use the Microsoft Jet database driver in excel mode (ConnectionStrings.com - Forgot that connection string? You will find it right here!) to access it like a db, read the file into a datatable, and then write it to disk as delimited text

See my recent edit to the other post about this topic being in the wronf section

reubenfoo · #5 (**permalink**) 11-25-2008, 9:30 PM

Firstly, i would be selecting the excel file which is pulled from macpac, from my computer, next i would click on the button convert.

Once converted, it would generate a text file. which looks something like that

--------------------------------------------------------------------------

BANK@@@@7010052@@@@@@@@@@@@@@@@@@@@@@@65123465@@@@ @@Orderin Party@@@@Sin Cash@@@@@@65123369@@@@@@@@

--------------------------------------------------------------------------

cjard · #6 (**permalink**) 11-26-2008, 4:52 AM

can you provide by way of forum attachment, a "before" and "after" file youre expecting from this process?

reubenfoo · #7 (**permalink**) 11-26-2008, 8:32 PM

i've attached before

before.png

and after screen shots.

after.png

cjard · #8 (**permalink**) 11-28-2008, 8:44 PM

using a connection string you find at ConnectionStrings.com - Forgot that connection string? You will find it right here! and the "Microsoft Access Database driver" in visual studio (for it is the Jet driver, it's just that jet can access excel too), [or OleDb if youre doing it in code rather than visual designer] are you able to connect to the spreadsheet and read its contents into a datatable?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)