Export Access table to Excel Table 1

[priac]

I will start by saying I am not a programmer. I have a database that is want to export from Access table to Excel table.
I am doing it now with " DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "inventory", "S:\Access\Adam\PdfFiles\inventory.xls", True" .
It works great but then I have to go to Excel and click on Insert Table to convert the to a table that is easy to use. Is there a way to do this in the Export???

 

[SkipVought]

Hi,

It can all be done from Excel via Data > Get External Data > From Access...

This opens a GUI similar to the MS Access GUI and employs similar SQL code.

Once you have composed the SQL code to your satisfaction, and it is exported to your Excel sheet, you have a Structured Table in your sheet. It can be Refreshed to get the current data in the Access table.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein