Recent content by antonsachs

Thank you, "! works My current code is: DoCmd.TransferSpreadsheet acImport, , strImportTable, strFullFileName, True, "!" & strImportRange works for importing from both open and closed Excel workbook.

Try saving your SQL statement as actual query - queries are precompiled, so while you lose time in saving - depending on you machine and hard drive (UGH!) - you should actually gain speed. On my top of the line machine, running db from RAMDrive, I get 25% to 35% speed increase by using actual...

I am an IT consultant, working with MS Access since 1992 (v1.1). Before that I've worked with microcomputers, early x886 and Apple. I have also worked with Excel (VBA), VB6, JavaScript, ASP, Assembler, C, C++, SQL Server (6.5 -2012) and some other languages and platforms. As a consultant, I've...