I got the same error (3349) when I try to import from Excel into a linked Access table.
-----
DoCmd.TransferS preadsheet acImport, , _
"tblCurrentPric es", rstBatch!DirPat h + rstBatch!Filena me, True, rstBatch!Range
------
where tblCurrentPrice s are linked to the front end app.
Any fix to this?
Reidar