Exporting Access tables to Ms Excel

[Lou_Reed]

i am trying to export an MS Access table from MS Access to MS Excel.



I think that I have the VBA code to do that. I also have a browse button I that created which allows the user to select the MS Access db from the directory.

The problem is that the files extension of the db is *.accdb. That includes everything in that db. I only want the table. So what do I do?

As far as I know there is no extension to only an MS Access table and if there were said extension then it would be buried in the db file.

So how do I export only an Access table.

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[Lou_Reed]

Let us drop this. I have found a much easier way. No need to answer this. Thanks anyway.

Respectfully,

Lou Reed

[orange]

How about sharing your much easier way with others?

[ArviLaanemets]

Somehow I have feeling, OP discovered ODBC queries

[orange]

Arvi,

Possibly. But, with over 1400 posts, Lou should be sharing solutions as a normal action (in my view).