set oxl = CreateObject("Excel Application")
oxl.visible
Set owb = oxl.workbooks.open(filename:=rst.fields("full_path "), readonly:=True, Password:="ops"
To this point, the file opens just fine
Next line of code
Docmd.Transfersheet acimport, acspreadsheetTypeExcel12, "mytable", rst.full_path, True, "A:AC"
is the line with the error.
If I remove the password from the file and ONLY execute the Transfersheet statement (not opening the file), it works fine. The extension is .xlsx and I've tried changing it to be .csv (same error) as well as changing acSpreadSheetTypeExcel12 to 12Xml(same error). Access version is professional Plus 2016.
Suggestions!
Thanks!