Hello Viewers ..I am developing C# based windows application and these Application Front end is MS Access...In this Application I want insert multiple records using one query...my query is ..
Insert into ReciverAddress(ReciverAddressId,ReciverName,ReciverCompany,ReciverAddress,ReciverState,ReciverCity,ReciveCountryCode,ReciverPostalCode,ReciverContact) values(1,'RAMU GUPTA','EVENZ INDIA','NEW DELHI,DWARKA MOR','Delhi','DWARKA',110078,118877,98768423764)
Insert into ReciverAddress(ReciverAddressId,ReciverName,ReciverCompany,ReciverAddress,ReciverState,ReciverCity,ReciveCountryCode,ReciverPostalCode,ReciverContact) values(2,'ROHAN GUPTA','KMK NETWORK','SURAJ MAL VIHAR','Delhi','NEW DELHI',612361,932749,98634872364)
Insert into ReciverAddress(ReciverAddressId,ReciverName,ReciverCompany,ReciverAddress,ReciverState,ReciverCity,ReciveCountryCode,ReciverPostalCode,ReciverContact) values(3,'RAJESH SHARGOHI','SSS','GHANDHI NAGAR,NEW DELHI','Delhi','LAXMI NAGAR',11006,110096,9716346947)
Insert into ReciverAddress(ReciverAddressId,ReciverName,ReciverCompany,ReciverAddress,ReciverState,ReciverCity,ReciveCountryCode,ReciverPostalCode,ReciverContact) values(4,'PALLAVI AGARWAL','KS Infotech','Uttar pardesh','Uttar Pradesh','MATHURA',110055,999871,98991273982)
but this query is not executed and Given same exception..Exception is
Missing semicolon (;) at end of SQL statement...so given same idea or your views to correct this Exception...Thank you..