Software

Ask something
Question Locked

how to copy the data from excel sheet to sqlserver table using a query

0 helpful
2 replies

by ravi_maduri_mca

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
i want to copy the data from excel sheet to a table in sqlserver using a query in sqlserver ,only just i want to run the query and i have to copy the data from that excel sheet to the table in sqlserver.becz i have the data which is needed for every database i don't want to copy that manually just i will create the table run this query.

2 replies

by thumbsup2

Export the excel spreadsheet to a CSV file, then import (insert?) it to sql. Sorry, I don't know the sql command. In MySQL, it's called insert.

This discussion is closed to new replies.