Export to Excel Structured Table

[OldCityCat]

Does anyone know if you can use "DoCmd.TransferSpreadsheet acExport," to put data into a Excel 2007 Named Table/Structured Table" in rather the a Named Range?




Thanks in advance for any and all suggestions


OldCityCat

[June7]

Don't understand. What is "Named Table/Structured Table". I have never used a named range in any exports to Excel.

[OldCityCat]

It's a new feature in Excel 2007 and some know it as a Named Table others as a Structured Table in Excel 2007 - basically it'a range that converted to a table.

When using the DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "QueryName", "C:\Test.xls",, "MyName"

the last argument can be a Named Range.
So you only export data to just that range. It new to me as well I just started using it.
Hop this helps

[June7]

Actually, I never used TransferSpreadsheet. I have only one procedure for export and it is updating an existing spreadsheet and the data is not within a continuous range. I have another procedure behind an Excel workbook that pulls data from Access.

You seem to have opened a new can of worms. I can't find anything besides your crossposts on other forums regarding this issue. Have you tried it?

[OldCityCat]

Yes, I'm using it with a Named Range, was trying to use a Named Table and that where I had issues.