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 wrote:
> dear kodali ranganadh
> there is no support
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 wrote:
>
> yes ..DTS/SSIS are the ultimate solutions for doing these kin
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 SSI
I think it is the best solution to import data from excel to sql
server.
On Mar 19, 1:57 pm, anna durai 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 wrote:
> > Hi aadi ,
>
> > plz try t
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 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/297
1. connect to excel using OleDB2. connect mySql using MySql connector
http://www.vbmysql.com/articles/vbnet-mysql-tutorials/the-vbnet-mysql-tutorial-part-3
3. use datareader from Oledb to insert data from excel to MySql database
On Tue, Mar 17, 2009 at 3:39 PM, aadi wrote:
>
> pls some one guide
You could buy some Books and start from there
Regards
Vignesh.R.Joshi
On Tue, Mar 17, 2009 at 2:09 PM, aadi wrote:
>
> pls some one guide step by step to import or convert excel sheet data
> into mssql database
> thanks and regds
> annadurai
>
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
