import excel range of more than 65000 lines to access -
"itemprop =" text "> When I import an Excel file (with a set limit to use the label labeled" Import Label "on line 10 Try to do detail "and the data begins at row 11), if the error is more than 65,000 lines then I am getting an error. Is there some additional setting that I do not know? The relevant code is that I use: DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12Xml, "New Table", C: \ document \ spreadsheet.xlsx, True, "Detail A10: Q100000 "I get the error message" run-time error 3011: Microsoft Access database engine object 'Details $ A10: Q100000' was not able to make sure that the object exists and said " If you spell your name and correctly the path then 'Description $ A10: Q100000' is not a local item, your own The Etvrk connection can check or server administrator " This command completely works for small Boundaries but totally not what races to the boundaries of more th...