objAccessApp.DoCmd.TransferText acImportDelim, m_strcSpecName, m_strcTableName, g_strLocalPath, False, ""
When it runs this line of code I get a Run-timer error '56': Application-defined or object-defined error. Unfortunately when I look this error code up in a list of Access error codes there is no 56. The code works fine in Access VBA, but when I put it in Excel I get error 56.
Can anyone help me with this elusive error code 56?
Edited by: Billkamm on Wed Oct 12 11:33:51 EDT 2005.