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 |
|
rvan
Starting Member
28 Posts |
 Posted - 2006-12-24 : 00:02:14
|
| Hello to All,I'm searching a way get Excel data into SQL database and tried this "insert" process that given me error. Already create a table call "original_purged" contain column fields. Can anyone give me some tips to show the problem? INSERT Original_PurgedSELECT OP_ID,RBDI,Title,Address,City,State,Zip,Plus4,Walkseq,Crrt,Endorse,City_rural,Dpb,Dpbc,updatedateFROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0', 'Data Source="C:Original_Purged.xls";User ID=Ryan;Password=dellonee1405;Extended properties=Excel 5.0')...[52117639]==========================================================Error occur.............Server: Msg 7399, Level 16, State 1, Line 1OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. Authentication failed.[OLE/DB provider returned message: Cannot start your application. The workgroup information file is missing or opened exclusively by another user.]OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80040e4d: Authentication failed.].thank youryan,RV |
|
|
Jeff Moden
Aged Yak Warrior
652 Posts |
Posted - 2006-12-24 : 00:43:13
|
| Was the spreadsheet open when you tried to import it? If so, close the spreadsheet and try importing again.Also, make sure the path for the file is correct... aren't you missing a backslash after the "C:"?--Jeff Moden |
 |
|
|
MohammedU
Posting Yak Master
145 Posts |
Posted - 2006-12-24 : 01:05:08
|
| Use DTS or SSIS to copy the data from spreadsheet...MohammedU |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
rvan
Starting Member
28 Posts |
Posted - 2006-12-26 : 14:47:35
|
Hi, MohammedUYes, I'm able to use DTS import excel table but in SQL server already have table title contained data and wants other tables continue to "Insert" from Query Analyzer by using statement.Thank youryan,quote:
Originally posted by MohammedU
Use DTS or SSIS to copy the data from spreadsheet...MohammedU
RV |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-12-27 : 22:44:53
|
quote:
Originally posted by rvan
Hi, MohammedUYes, I'm able to use DTS import excel table but in SQL server already have table title contained data and wants other tables continue to "Insert" from Query Analyzer by using statement.Thank youryan,quote:
Originally posted by MohammedU
Use DTS or SSIS to copy the data from spreadsheet...MohammedU
RV
Did you read the link I posted?MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
|
|
How to Insert Excel data into SQL database?