build graph

[bbng]

i'm using vb6 and access as my database. my work is need graph. the value in the graph is depend to the data stored is database. how can i put the data from access to the excel worksheet. any component need? can i use ole to draw the graph?what component is necessary to import ? the main problem is i don't know how to put value from database to worksheet...

thank you for u all help.


to pro2:
i don't understand the line you are using?is that a command or method or variable?

[Edited by bbng on 10-03-2000 at 12:27 AM]

[pro2]

try with a line
and do like:

Dim line1 as new line2
line2.visible=true
line2.left=line1.left + 1

I know the code doesn't work very well but it's a way you can try to go in ..