Data transfer from Jet to SQL Server

[Einat Lapid]

Hi,

I'd like to transfer Jet data to SQL Server. I have a connection from the
Jet machine to SQL Server but not the other way around (which exclude the
linked server solution).

Idealy I would like to do somthing like this :

insert into SQL.TABLE select * from Jet.Table

Can I do that ? What is the spesific syntax ?

Thanks,

Gil

 

[Rick Brandt]

Hi,

I'd like to transfer Jet data to SQL Server. I have a connection from
the Jet machine to SQL Server but not the other way around (which
exclude the linked server solution).

Idealy I would like to do somthing like this :

insert into SQL.TABLE select * from Jet.Table

Can I do that ? What is the spesific syntax ?

If you create a link to the SQL table in your Access app then what you have
above is exactly the syntax you need if you just remove the "SQL." and "Jet.".

 

[Einat Lapid]

Thanks - is there way to do that without modifying the source (jet)database
?