I am importing an excel spreadsheet into one of my tables using access 2000 via the TransferSpreadsheet command.
The only problem I am facing is that there are times when one of the fields are going to be blank. When I try and import this data, it creates an error table named something like "Sheet1$_ImportErrors" identifying the blank fields.
Is there any way of stopping this from generating the error table? I have tried making the column not required but it still does it. The data imports fine, it's just this importerror table is annoying and they will just keep on building up if they are not deleted.