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

Einat Lapid wrote:
> 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.".

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

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


"Rick Brandt" <(E-Mail Removed)> wrote in message
news:EqlHf.11886$(E-Mail Removed)...
> Einat Lapid wrote:
>> 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.".
>
> --
> I don't check the Email account attached
> to this message. Send instead to...
> RBrandt at Hunter dot com
>