I am using Access and Excel 2002 - trying to export a table to an excel ss by using
but when I do, access reports an error message saying too many lines - the only thing is that I am only exporting 18,340 records. Any ideas?
Code:
DoCmd.RunSQL "UPDATE tblMaintenanceHistory SET tblMaintenanceHistory.MaintenanceDate = Date() where MaintenanceDescription = ""Export Regional Price List"";", 0