importing data

[ronaldrahme]

i wanna have a script that imports data from an excel file to my database, how can it be done through a 'script'?

[GeekRahil]

Get Toad! It lets you query data from multiple sources and makes scheduling tasks, comparing data and creating reports.

[abusaud]

u can use win runner to load excel data as database bby using datadriven test

[ronaldrahme]

I got it
i used the following script


insert into openrowset('microsoft.jet.oledb.4.0','excel 8.0;database=c:\fiches.xls;',
'select * from [sheet1$]')
select * from tablename


hope that would help someone too