speeds up transferspreadsheet action

hello people

could do with some urgent help here guys/gals,

I am trying to import a spreadsheet in to a table using the folowing command

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel7, "import_data", filepath, False, "monday!F6:" & "AY" & cntr


but it takes ages. this file is open whilst importing as i make changes to it b4 i import. does ne 1 know how to speed the process up.

also does any1 know how to import all sheets (mon - Tue) in 1 go rather than having to repeat the code seven times for the individual sheets


thanks in advance

you could use ado and read it in if all you want to do is import

link to import excel to access