i wanna have a script that imports data from an excel file to my database, how can it be done through a 'script'?
Printable View
i wanna have a script that imports data from an excel file to my database, how can it be done through a 'script'?
Get Toad! It lets you query data from multiple sources and makes scheduling tasks, comparing data and creating reports.
u can use win runner to load excel data as database bby using datadriven test
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