Export from datatable to excel

[gloringg]

Hi,

I am new to vb. I need some help.

I have a database ms access 2003 and using vb 2008 created an application.
Now, I have the database name as CompanyINFO. and in that i have a table as primary.

all i wanted to do is to have a button to export.
when the user clicks it. the whole table should be exported as a excel file and should be saved on the desktop as CompanyINFO_Primary_mmdd.

I tried various type but was not even close to what is required.

Can some one please help me.

Thanks