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 |
|
senthil_mca80
Starting Member
10 Posts |
 Posted - 2008-02-11 : 14:08:29
|
| Hi, is there any way to import the excel data to sql server 2000?. your help is much appriciated.Thanks,Senthil |
|
|
senthil_mca80
Starting Member
10 Posts |
Posted - 2008-02-11 : 14:15:49
|
| I am using the following query. but it is return the error message.Excel file name is: NovReleaseScriptsList_ModuleOwner.xlsexcel sheet name is : module_ownerSELECT * INTO XLImport5 FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=C:\NovReleaseScriptsList_ModuleOwner.xls', 'SELECT * FROM [Module_Owner$]')Senthil |
 |
|
|
hey001us
Posting Yak Master
185 Posts |
Posted - 2008-02-11 : 14:24:50
|
| what is the error msg shows?hey |
|
|
|
senthil_mca80
Starting Member
10 Posts |
Posted - 2008-02-11 : 14:30:04
|
| Here is the error message.Server: Msg 7399, Level 16, State 1, Line 1OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. [OLE/DB provider returned message: The Microsoft Jet database engine could not find the object 'Module_Owner$'. Make sure the object exists and that you spell its name and the path name correctly.]OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IColumnsInfo::GetColumnsInfo returned 0x80004005: ]. |
|
|
|
hey001us
Posting Yak Master
185 Posts |
Posted - 2008-02-11 : 15:03:23
|
| Well based on the error message:- you need to check your file name exist in right path and spell check your file name- The file exist in same sever that SQL server running?- Check you got access to the file?hey |
|
|
|
senthil_mca80
Starting Member
10 Posts |
Posted - 2008-02-11 : 17:19:51
|
| Hi, I have used the correct file name and have the full access to file. SQL server is running on production server. I dont have the access to production server. do i need to place this excel file in to the production server?. is there any other way we can do this?Senthil |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-02-11 : 20:35:42
|
quote:
do i need to place this excel file in to the production server
Yes. This statement "Database=C:\NovReleaseScriptsList_ModuleOwner.xls", is referring to C:\ of the Server not the client
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Import excel data