Import access db objects into blank database

I have code in databases that exports all the objects and it does this successfully.  Now, I need to re-import these objects into a blank database.  I have done this before (OK, I don't know where I put the code!) so I know it works.  But I cannot get this test code to bring in the data.  I keep getting the error message: 2487 The Object Type argument for the action or method is blank or invalid.  But all arguments are populated.  The path is correct and tables names are correct.

Public Sub ImportDatabaseObjects()
On Error GoTo ErrorHander

'Import tables
Application.LoadFromText acTable, "t_lu_category", s_SYBASELinkPath & "Table_t_lu_category.txt"
Debug.Print s_SYBASELinkPath


MsgBox "All database objects have been exported as a text file to " & s_SYBASELinkPath, vbInformation

Exit_ErrorHandler:
    Exit Sub
    
ErrorHander:
    MsgBox Err.Number & "Description: " & Err.Description
    Resume Exit_ErrorHandler
End Sub

Select all Open in new window