Study the format of the text file and excel file to see how data is
delimited. Use notepad or word to do this. Typically the text file data
would be delimited with a tab or a space (hopefully a tab). In the excel
format, there is a lot of extra data included to tell excel how to set
things up. Look for a key or figure, or word that will tell you the
beginning of the "good data". Then read the data in a line at a time using
the split function to separate each line into an array of data for that
line. I would stay away from the access database unless this is a student
project.



Bart



_____

From: visualbasic6programming@yahoogroups.com
[mailto:visualbasic6programming@yahoogroups.com] On Behalf Of Raghavan
Manikandan
Sent: Tuesday, June 30, 2009 6:33 AM
To: visualbasic6programming@yahoogroups.com
Subject: [Visual Basic 6 programming] Data collection from Excel / Text file
Using VB 6









I have given below the activities done in Excel VBA:-

1) I have a Main excel working file where I need to
download the data from various bank statements in a
specified format.

2) The respective bank file will be opened through main
working file by the user and downloads the data in a
specified format on daily basis.

The above mentioned operation was done in EXCEL VBA. As
successfully going on the project for some Target
assessmemnt, we are planning to implement the same with VB6
and Access database.

I would like to know, how can we open a bank statement
(text format & excel format) through VB6 coding and how
can we access from VB6 to text file/excel file to collect
the data.

Could anyone help me at the earliest?

Thanks & Regards
Manikandan Raghavan





[Non-text portions of this message have been removed]