Help pls... insert data from access to SQL server

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

Help pls... insert data from access to SQL server

Author

Topic

ed9teen
Starting Member

6 Posts

Posted - 2008-01-11 : 04:57:51

hi, can someone help me.. how to insert database from access database to sqlserver... please help..

Here is my codes below but it's not work....

Insert into magpatoc.dbo.RSOTransfer
Select * FROM ('Provider=Microsoft.Jet.OLEDB.4.0;',
'Data Source=c:\CopyOfRSODB.mdb;User Id=admin;Password=;',
'SELECT * FROM FinalCustItemRSO')

ed9teenMagnaza

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2008-01-11 : 07:16:24

Try this:

Insert into magpatoc.dbo.RSOTransfer
Select * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'c:\CopyOfRSODB.mdb','SELECT * FROM FinalCustItemRSO') as tbl

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

ed9teen
Starting Member

6 Posts

Posted - 2008-01-11 : 07:44:25

there is an error with the codes below..
this is the error:
OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Could not find installable ISAM.".
Msg 7303, Level 16, State 1, Line 2
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".

Insert into magpatoc.dbo.RSOTransfer
Select * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'c:\CopyOfRSODB.mdb','SELECT * FROM FinalCustItemRSO')

is there any idea..

but anyway this codes below work fine but it doesn't insert any data..

INSERT INTO magpatoc.dbo.RSOTransfer
SELECT *
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'c:\CopyOfRSODB.mdb';'admin';'', FinalCustItemRSO)

can someone know what wrong with it or conflict of datatype
talking about datatype what is the compatible datatype for access to SQL server..

please help..

ed9teenMagnaza

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources