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