How to connect data base from VB 6.0 to MS excel sheet? Datas should save in excel?

[hhgv]

Hi,
Friends, I need help from u people for my project. i have attached the jpeg design details through this conversation.pl ease find the attachment and help me to complete this project.

My doubt Is:

1.How to connect VB to Excel sheet?
2.VB should work as front end user and excel sheet use as back end user to save the data's in excel sheet.
3.Codings for Command button, if the button click for second time Command button should not work for more then 1 click. for this i need coding.

I mentioned details in the jpeg image.

By Harish.Gv
<email removed>

[Poet]

Create a reference in VB6 to the Microsoft Excel Object Library and the Microsoft Office Object Library.

Using calls to the Excel object model, you can modify Excel as you would in a VBA instance. Great information available here: http://msdn.microsoft.com/en-us/libr...ffice.14).aspx