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
Application.LoadFromText acTable, "t_lu_category", s_SYBASELinkPath & "Table_t_lu_category.txt"
MsgBox "All database objects have been exported as a text file to " & s_SYBASELinkPath, vbInformation
MsgBox Err.Number & "Description: " & Err.Description