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 |
|
sanjay5219
Posting Yak Master
240 Posts |
 Posted - 2010-09-08 : 14:49:11
|
| Dear All,I have created one table and one excel file and i was trying to upload but i am getting this error messageOLE DB provider 'Microsoft.Jet.OLEDB.4.0' does not contain table 'Sheet1'. The table either does not exist or the current user does not have permissions on that table.Please Help |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-09-08 : 15:15:30
|
| try Sheet1$ |
 |
|
|
sanjay5219
Posting Yak Master
240 Posts |
Posted - 2010-09-09 : 03:59:47
|
| Tried but same error |
|
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2010-09-09 : 04:01:28
|
| Can you post the full query you are using. |
|
|
|
sanjay5219
Posting Yak Master
240 Posts |
Posted - 2010-09-09 : 08:29:21
|
| SELECT * INTO TT FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0','Data Source=E:\Book1.xls;Extended Properties=Excel 8.0')...[Sheet1$] |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-09-13 : 15:11:54
|
| tried SSIS or import wizard? |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Error in Excel UPload