Convert XLS into Txt
- Thread starter reubenfoo
- Start date
cjard
Well-known member
- Joined
- Apr 25, 2006
- Messages
- 7,081
- Programming Experience
- 10+
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
Also your question has little to do with Visual Studio itself (the environment you write programs in) so this is probably the wrong forum
Last edited:
reubenfoo
Member
XLS to TXT
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.
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
Well-known member
- Joined
- Apr 25, 2006
- Messages
- 7,081
- Programming Experience
- 10+
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
..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
Member
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@@@@@@@@
--------------------------------------------------------------------------
Once converted, it would generate a text file. which looks something like that
--------------------------------------------------------------------------
BANK@@@@7010052@@@@@@@@@@@@@@@@@@@@@@@65123465@@@@@@Orderin Party@@@@Sin Cash@@@@@@65123369@@@@@@@@
--------------------------------------------------------------------------
cjard
Well-known member
- Joined
- Apr 25, 2006
- Messages
- 7,081
- Programming Experience
- 10+
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?
