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 |
|
rivettazzo
Starting Member
3 Posts |
 Posted - 2010-02-10 : 02:49:21
|
| I need to insert remote sql server data into access and i tried to eexecute a "strange" query with OPENDATASOURCE but i get the following error:Syntax error in FROM clause. Where is the error? Is there a way to do what i have to do? (SQL SERVER -> ACCESS)I can ONLY ACCESS the sql server and i cant modify anything. In the server (access) i can only do query. set connACC=Server.createobject("adodb.connection") strConnectACC = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("../mdb-database/gestioneRIVE.mdb") connACC.Open strConnectACC sqlACC_DEL = "INSERT INTO STDParametriAzienda SELECT * FROM OPENDATASOURCE('SQLOLEDB','Data Source=IP;User ID=sa;Password=*****').NOMEDB.dbo.NOMETABELLA" connACC.execute(sqlACC_DEL) |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-10 : 02:53:46
|
| did you try executing this in query analyser?------------------------------------------------------------------------------------------------------SQL Server MVP |
 |
|
|
rivettazzo
Starting Member
3 Posts |
Posted - 2010-02-10 : 04:17:33
|
| No, i'm a newbie and i never use that tool... I ever used Access and i never need to analise my (very simple) query... It work with access DB too or only with sql server? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-10 : 04:24:23
|
| Not sure about access. but it should work with SQL server------------------------------------------------------------------------------------------------------SQL Server MVP |
|
|
|
rivettazzo
Starting Member
3 Posts |
Posted - 2010-02-10 : 04:59:58
|
| In access i get the error reported in my post.. I solved problem importing row x row but is too slower!!!!!!!!!! 10 minutes... If anyone can help me... HELP!! |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2010-02-10 : 05:24:21
|
| Try creating Linked tables to SQL Server database and check the performance.Harsh Athalyehttp://www.letsgeek.net/ |
|
|
|
msuneerbabu
Starting Member
6 Posts |
Posted - 2010-02-10 : 06:33:03
|
| this may helpfulhttp://office.microsoft.com/en-us/access/HP030893711033.aspx |
|
|
|
|
|
|
INSERT INTO STDParametriAzienda SELECT * FROM OPEN