Tuesday, July 9, 2013

import excel data to sql server

First Create Table, it is better to name as sheet column name.
Then Copy the data  [ Ctrl + C ]
import excel data to sql server

Go to Table Right Click and select Open Table

import excel data to sql server
Now left Click
import excel data to sql server
The Area will be highlighted now right click and paste
import excel data to sql server
Happy Excel ...data is in sql now..
import excel data to sql server

No comments:

Post a Comment