Hi All,
I'm running into an issue with one of my file imports. The particular file imported is an .xlsx file with upwards of 57,373 KB.
The file is located on a network drive - as the database being used to import it (though different locations).
I'm using the DoCmd.TransferSpreadsheet method to import the data into a specific table in the DB (table is in a backend DB - which is linked to the Front End DB where the Import Button is located). But due to the size of this particular file, it's seriously SLOW to the point where it's freezing up the database and really bloating the heck out of the backend. Is there a more logical way to do this rather than what I'm currently using??
Code:
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, strImportTable, strFileName, True