masoud_sedighy
Registered User.
- Local time
- Today, 10:44
- Joined
- Dec 10, 2011
- Messages
- 132
after migration to sql when i run the macro for running 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"
Reply With Quote Reply With Quote
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"
Reply With Quote Reply With Quote