HOW DO I INSERT USING OPENQUERY INTO A ACCESS LINKED FILE

[bridor]

hi!
i hope someone will help!
i'm using sqlserver 2k
i've linked a microsoft access (*.mdb) as a linked server into my sqlserver
using a dsn with a microsoft ole db provider for odbc driver
i'm able to execute selects statment from that linked file as:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
select * from openquery(mylinkedmdb,'select * from mylinkedmdb_table')
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

my problem is that i 'm not able to execute insert statment into that linked
server
i'd like someone tell me how is that done!!

i've tryed :

insert into mylinkedmdb.tbname(a,b,c)
select a,b,c from sqlservr_tablename

and

insert into mylinkedmdb.tbname(a,b,c)
values (a,b,c)

and

insert into openquery(mylinkedmdb,'insert into mytable ( a , b , c )')
values (a , b , c )

without success

thanks! muchachos!
carlos

[Russell Fields]

carlos,

Have you tried INSERT ... EXECUTE ('string') where the string is your
OPENQUERY statement?

Russell Fields
SQL Server MVP

"bridor" <crodr...@hybridor.com> wrote in message
news:#b$F1olrBHA.2632@tkmsftngp04...

[Xiaoyu Li [MS]]

Hi,

How about using the following code:

select * FROM
OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'\\RemoteComputer\Share\Mydb.mdb';'admin';'', Table1)

Xiaoyu Li
Microsoft SQL Server Support

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.