Quality is delighting customers
I work on mySql, You can use in this way,
1. Take number of columns in excel sheet
2. Put the 1000 records which you want to insert
3. Add one one column in each filled column (to add commas and single quotes)
C1 C2 C3 C4 C5 C6 C7
(' a '.' b ',' c '),
4. Now write your query in query browser
insert into 'table name' values...
5. Copy the data from excel sheet and paste next to query
6. and then execute query.
(* if some unnecessary spaces are getting added between two values u can paste data from excel sheet to
PSpad and remove spaces by 'find replace' )
I am not sure whether the way i use is effective..
Please let me know any other easy way.
hw r u? Hope everything is 5n.
I have tried, but not working
i guess i did in wrong way
table & colum which i created is
Column: Emp_id,Emp_Name, Emp_Add
so explain how to give the value in the below command
Insert into Employee Values.....
I tried in SQl Server 2005 not working
what i tried is
insert into Employee Values
Error msg which i got is "Incorrect syntax near ',' "
Insert into Employee values
(value of Emp_id, value of Emp_Name, value of Emp_Add) and enter data then press "Enter"
and then "/" now u can enter the second record .. like this u can enter "n" number of records...
LOAD DATA LOCAL INFILE ‘C:\\temp\\yourfile.csv’ INTO TABLE database.table FIELDS TERMINATED BY ‘;’ ENCLOSED BY ‘”‘ LINES TERMINATED BY ‘\r\n’ (field1, field2);
1st create xls file add data in that .
Load data local infine 'path of .csv file' into table tablename field terminated by .... etc
Hi Bheemlanaik and Shital patel,
Thanks for replying my query
u can also try ecxel sheet(formula bar) to create insert query