1.)Rght Click on the database that contains the your original table.
2.) Open new Query Window
3.)Paste this into query
5.)Replace the YourDATBSE with your own databse
6.)Replace the MYTableNAME with your own tabl name
1.)Rght Click on the database that contains the your original table.
2.) Open new Query Window
3.)Paste this into query
5.)Replace the YourDATBSE with your own databse
6.)Replace the MYTableNAME with your own tabl name
USE YourDATBSE GO INSERT INTO MYTableNAME (FirstColoumn, SecondColoumn) VALUES ('FirstRec',1); INSERT INTO MYTableNAME (FirstColoumn, SecondColoumn) VALUES ('SecondRec',2); INSERT INTO MYTableNAME (FirstColoumn, SecondColoumn) VALUES ('ThirdREC',3); INSERT INTO MYTableNAME (FirstColoumn, SecondColoumn) VALUES ('FourthREC',4); INSERT INTO MYTableNAME (FirstColoumn, SecondColoumn) VALUES ('FifthREC',5); GO