Maybe a simple Google search would help you? http://www.google.com/search?hl=en&q=SSIS+load+excel+file+into+SQL+Server&aq=f&oq=
2nd item on the list results: http://blogs.techrepublic.com.com/datacenter/?p=205 On Mar 21, 1:36 am, anna durai <downtown...@gmail.com> wrote: > dear kodali ranganadh > there is no support of dts in sql2005, and i donot know ssis, can you > guide me step by step, or can you suggest me any site which teached ssis > > thanks and regds > annadurai > > On 3/20/09, kodali ranganadh <ranganadhkod...@gmail.com> wrote: > > > > > > > > > yes ..DTS/SSIS are the ultimate solutions for doing these kind of Data > > Trsnformation. > > > for simple kind of operations like tranfer bliendly from Excel to SQL > > Server, you can use IMPORT/EXPORT wizard > > > if do you need large data transformations in the middle of data moving for > > most best solution is SSIS. > > > regards > > ranganadh kodali > > > On Thu, Mar 19, 2009 at 10:56 PM, PaaPee <paa...@gmail.com> wrote: > > >> I think it is the best solution to import data from excel to sql > >> server. > > >> On Mar 19, 1:57 pm, anna durai <downtown...@gmail.com> wrote: > >> > thank u tushar, i will try it out and come back to you > > >> > thanks and regds > >> > annadurai > > >> > On Wed, Mar 18, 2009 at 2:34 PM, Tushar Gurav <tush.gu...@gmail.com> > >> wrote: > >> > > Hi aadi , > > >> > > plz try this out . > > >> > > What will be the result good or bad > > >> > > plz forword it me too > > >> > >http://davidhayden.com/blog/dave/archive/2006/05/31/2976.aspx > > >> > > Thanking you. > > >> > > -- > >> > > Tushar > > >> > -- > >> > ANNADHURAI > >> > DOWNTOWN EXPRESS / CHENNAI LOCAL COURIER SERVICE > > >> > 98400 51690- Hide quoted text - > > >> > - Show quoted text - > > -- > ANNADHURAI > DOWNTOWN EXPRESS / CHENNAI LOCAL COURIER SERVICE > 98400 51690- Hide quoted text - > > - Show quoted text -
