Converting MDB to XLS Format

Hi Good Day to All of You, I got this small problem which is to convert one of the table inside the database(.MDB)into a .Xls format. The problem is how do i specific that particular( e.g c:\db2.mdb) database & I only want the table "Form" to be save in (.xls) format. Can i used createobject ? Please if you can help me, do write an example code for me as I'm not really good with Win API. THKS a lot for your help

If I understand you correctly, you want to save all the data on your table in an Excel spreadsheet...To do it, with the table open, click Tools, Office Links, Analyze It with MS Excel.

This will put the data to an Excel spreadsheet.

If you prefer code:

Code:

---

docmd.outputto actable, "TableName","MicrosoftExcel(*.xls)","PathForOutput",False,""

---

Hope that helps

------------------
Morgan
[email protected]
My Web Page

To do it all with code and no automation, see:
http://www.smithvoice.com/vb5expt.htm

Shows how to export a table or any sql recordset to excel or lotus or html or whatever, even gives full source code for full conversions and a new Excel<>Jet converter utility. DAO or ADO.

Worth looking into, saves a lot of time and effort (appears to be the actual underlying code used by MS for crossformat exports)

------------------
http://www.smithvoice.com/vbfun.htm