you can import XL sheets with:
docmd.TransferSpreadsheet acImport ,acSpreadsheetTypeExcel12,sTbl, sFile, true,sSheetName
you can import ODBC tables via other data sources by:
0.use ODBC to link the table as an external table,(done once)
1. run an append query to import the data.
Sorry I have made a Mistacke my circle goes out of range
I want to import Access Tables not ODBC
I want a button on Access form to import tables instead of Access menu
I just want to open this Access import dialogue and the other work should manually
Ok leave it I have solved this myself via Macro code