Jamie Collins wrote:

strSQLToExecute = "SELECT [" & strItemToOutput & "].* INTO [Excel
8.0;Database=" & strOutputPathAndFile & "].[" & strItemToOutput & "]
FROM " & strItemToOutput

Good to know it still works, even in Access2003.

Sorry, I thought I was posting to one of the Access groups. For Excel
users who missed my subtle point, see:

You cannot change, add, or delete data in tables that are linked to an
Excel workbook in Office Access 2003 or in Access 2002:
http://support.microsoft.com/kb/904953/en-us

"Because of legal issues**, Microsoft has disabled the functionality in
Access 2003 and in Access 2002 that let users change the data in linked
tables that point to a range in an Excel workbook."

The same applies to Jet SQL code executed anywhere from with the Access
UI (query object, VBA code, etc) that would directly update Excel data.

** For the story on the 'legal issues', see:

Lawsuit forces users to update Microsoft Office:
http://www.theregister.co.uk/2006/02..._infringement/

"Users of Microsoft's Office and Access packages have been told they
will have to install updates as a result of a patent infringement
dispute between Microsoft and a Guatemalan inventor that has cost the
software firm almost $9 million in damages..."

Jamie.

--