exporting Access table to excel + DoCmd object.....urgent, please help!
Posted on 2004-09-14
Hi, I am trying to use DoCmd object to export data from Access database to excel. I found this sample but when I applied to my code (vb.net win app.) It said DoCmd is not declared.
DoCmd.OutputTo(acQuery, "qry_month", "MicrosoftExcel(*.xls)", "D:\Recertifications.xls")
Is it right to use it and how to declare the object? It is urgent. Please help