Pulling database information from visual basic to Excel

[Qais]

How can I take the data from form in database & save it as excel sheet by clicking a button named "export data"
Thank you

[debasisdas]

What is the source database that you are using ?

Some of the source data types may not be populated properly in an excel sheet.

By the way what is the code that you are working on ?

[twinnyfo]

There are multiple ways you can do this. What code have your tried thus far? We can help guide you from there....

[Killer42]

You didn't provide us with much information. But reading between the lines a bit, you want to do this from a form in MS Access.

I suggest you hit the help built into Access, and look up exporting to Excel. It has built-in functions to do so.

The details depend on how you want to do it, but I'd start by checking out the TransferSpreads heet action.