Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
renu
Starting Member
47 Posts |
 Posted - 2007-10-09 : 03:24:56
|
| i have to export the data from excel sheet to database table. for that i created linked server in sql 2000. after creating i get the SQLOLEDB error when i expand the linked server in enterprise manager.Can anyone help me in solving this issue. |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
renu
Starting Member
47 Posts |
Posted - 2007-10-09 : 05:00:47
|
| first of all what i have to do to export the datas from excel sheet to database tables |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-10-09 : 05:01:24
|
quote:
Originally posted by renu
first of all what i have to do to export the datas from excel sheet to database tables
Did you read the link I posted?MadhivananFailing to plan is Planning to fail |
|
|
|
renu
Starting Member
47 Posts |
Posted - 2007-10-09 : 05:20:44
|
| ya i read but i didnt have the linked server. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-10-09 : 07:18:12
|
quote:
Originally posted by renu
ya i read but i didnt have the linked server.
Didnt you try OPENROWSET query?MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
exporting data from excel sheet to db table