Import external ACCDB/MDB without specifying table name

[LB79]

Hi all,

This should be simple but...

I have an automated function to import external Access tables to my database (there is only ever 1 table in the external ACCDB/MDB), BUT the names of the external tables are different.
How can I import a table without specifying the name? (ie default import the only table abvailable)

DoCmd.TransferDatabase acImport, "Microsoft Access", Me!_txtPath, acTable, [B]TableName[/B], "tbl_MyTable", False

Thanks

 

[vbaInet]

DLookup() the only table in MSysObjects and use that.