i'm having data in access database, so for each row i need to create graph using ms chart control or otherthan that also, that should be using visual basic

i'm having data in access database and i need to create graphs using that data, like for each record one graph. so can u tell me how?(source code should be better) and i'm having text file so i need to convert that textfile into access database using visual basic, my text file looks like this:        
1-2-98      john     1234      mary     5678    robert   99999  
               bethi    123456  mash   12345  elizabeth   786576
               goraie  576576  santa  576576 student  6715276    2-3-98     john    23232     mary   232323    robert   232323
              bethi    343434   mash  433434   elizabeth 34343
            goraie   3434365 santa 54545 elizabeth  867676

so which is better way to convert this textfile in to  *.MDB
awaiting for reply...
thanking you....
KEETHAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
SRIVBConnect With a Mentor Commented:
IN VB, THERE IS A CONTROL CALLED MSCHART CONTROL WHICH IS AVAILABLE FOR DRAWING CHARTS.  FOR THIS YOU SHOULD ADD THAT CONTROL LIKE ANY OTHER ACTIVEX CONTROL INTO YOUR PROJECT.  

THAT CONTROL HAVE SO MANY PROPERTIES, THAT DETERMINES THE TYPE OF THE CHART, X AXIS, Y AXIS ETC., THESE PROPERTIES CAN BE EASILY SEEN FROM THE PROPERTY PAGE OF THAT CONTROL.

THIS CONTROL ACCEPT A TWO-DIMENSIONAL ARRAY FOR THE DATA AREA WHICH IS GOING TO PLOT.  

YOU CAN EASILY FOUND ALL THE NEEDED HELP IN THE ONLINE HELP SECTION IN VB, SEARCH BY THE WORD "MS CHART".

IN ACCESS YOU CAN IMPORT A FILE, AND CONVERT IT AS A TABLE.  FOR THIS CREATE A DATABASE, AND IMPORT THE TEXT FILE INTO THIS DATABASE AND SAVE IT AS A TABLE
0
 
KEETHAuthor Commented:
Edited text of question.
0
 
KEETHAuthor Commented:
i need source code for that!
thanx
0
 
SRIVBCommented:
yes, the source code for the above can be found in VB Online Help.  You can easily found that code.  It is too large to state here.
0
All Courses

From novice to tech pro — start learning today.