I load excel data into access table by using this bottom code.
a progress bar appear really quickly that shows the loading.Code:DoCmd.TransferSpreadsheet acImport, ,"table", file, true, "Sheet1!"
It's there away to disable or not show the progress bar until the data is loaded and then to turn it back on ?