I am trying to import a 14 tab Excel xls document into Access and it is taking over two hours. Each tab has the same type data and only the first tab has headers, there are 15 columns and the Excel document is 253kb.
I need help to get the time to import dramatically reduced. Any suggestions?
I have tried a macro and also vba.
Thanks for any help you can give me,
Ralmanza
I need help to get the time to import dramatically reduced. Any suggestions?
I have tried a macro and also vba.
Thanks for any help you can give me,
Ralmanza