hi
i have AN access database ,which in one part of it will analyse a big amount of data with excell sheet format
i am using this code to import the sheet to my database
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "Calls", "d:\My Documents\myfile.xls", True, "details!b1:h1068"...