Exporting a table in an MDB file from within VB to a DBF file format can be
easily accomplished by using SQL: SELECT ...INTO...IN statement. In the
'IN' I'll simply include the external file name and the ISAM string needed
as defined in the Installable ISAM section of the VB.INI file (i.e. dBase
IV=C:\WINDOWS\SYSTEM\XBS200.DLL)

I would like to be able to export a table in an MDB file to Microsoft
Excel. I was under the impression that we can use the same idea by pointing
to a valid DLL (as above) to export to Excel.

1. Does a DLL file exists (such as XBS200.DLL for DBF format) to export
data from Access to Excel ? I couldn't find anything in VB or any
documentation that points to this direction.

2. If not, is there an easy way to directly transfer data from MS Access
format to Excel format ?

Of course, one easy way would be to transfer the table to DBF and then let
Excel read directly the DBF file. However, this is not exactly the solution
I am looking for.

I would appreciate any help on the above.

Naim Bentahar.

Hope this helps,

Ray Smith