August 27, 2010 at 12:19 am
Hi Frnds,
Can u guide me, how to insert the data's from excel sheet to a table in ms sql 2005 ?
For Eg : I am having excel sheets containing 15rows, i want insert those into a table named TABLE_A.
Thanks in advance
August 27, 2010 at 1:30 am
Hi,
Right Click on the Database->Tasks -> Import data
you can import data from excel to the Table_A with mapping options.
or U may go with SSIS
--
Sasidhar Pulivarthi
August 27, 2010 at 1:33 am
The Import Wizard works great if you only have to do this once. If it's something you'll do regularly, I recommend SSIS. You can use the Import Wizard to create and save a basic SSIS package for this.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply