speeds up transferspreadsheet action

[vinesh]

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

[adocwra]

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

link to import excel to access