in my access database there are more than of 20 append queries and source data comes from of a excel file, before migration to sql i import this excel file to my database with a macro and inserting records in a big table in ms access and from this access table i appended records from different fields to other tables with defining (set warning false) for the macro.
now after migration to sql when i run the macro for running these append queries i got alot of error like "you can not set null value...." and error "primary key could not be duplicate" , ....
i have tried to correct these queries with using NOT IN (SELECT.....) in the append queries but i still got error about these append queries and i can't manage the errors and i have doubt when i try to import a excel file
before in ms access i did not have these errors if it had, ms access continues job until finished appending records and for duplicate or null value does not terminate the program.
is there any option in sql server when running append queries does not terminate the execution for the null value or duplicate primary key like what ms access does in the macro "set warning false"