Most efficient method of exporting a table or recordset to Excel

M

Mark

Quartz

Check out docmd.transferspreadsheet in the VB help.

Mark
-----Original Message-----
I am relatively new to programming Access. I'm using Access 2002.

I need to develop a programmatic method for exporting
Click to expand...
both an entire table as well as a recordset to Excel.
I would like to get some input and suggestions regarding
Click to expand...
the most efficient and stable methods for accomplishing
this. It looks like there are a number of methods to
choose from: ADO, DAO, SQL, VBA and every combination
thereof. I have heard (mostly from reading this forum)
that there are issues using some methods.
 
Top