Link to home
Create AccountLog in
Avatar of Charles Baldo
Charles BaldoFlag for United States of America

asked on

Insert SQL Data from Different Server

I need to write  a sql server statement that will insert data into a table from a table that is on a different physical server.  How can I do this?
ASKER CERTIFIED SOLUTION
Avatar of Kyle Abrahams, PMP
Kyle Abrahams, PMP
Flag of United States of America image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
I'd say linked server or just linked table, if You have msaccess it's as simple as create table-> liked table->path.
insert values into table from @linked_table
Avatar of Charles Baldo

ASKER

Thanks