Transfer date between MSSQL <<>> MSAccess - SQL

Welcome Guest

Search | Active Topics | Members | Log In | Register

IT-Coder Forums » Data Access » SQL » Transfer date between MSSQL <<>> MSAccess

Transfer date between MSSQL <<>> MSAccess

Options · View

Previous Topic · Next Topic

Wasilev

Posted: Friday, December 28, 2007 2:51:37 PM

Rank: Member

Joined: 10/28/2007
Posts: 8
Points: 24
Location: bulgaria

Hi gays,
how do I can transmit the table-data of MSSQL to MSAccess as well back?

fu-sign.com - my asp.net blog

theboss

Posted: Friday, December 28, 2007 2:55:20 PM

Rank: Administration

Joined: 2/10/2007
Posts: 77
Points: 417

just simple use Microsoft SQL Enterprise SQL Studio 2000 , there have bult-in tool for exchange data from different data source(include and .csv files).

Wasilev

Posted: Friday, December 28, 2007 3:23:26 PM

Rank: Member

Joined: 10/28/2007
Posts: 8
Points: 24
Location: bulgaria

I am using SQL Server Management Studio Express and 2003 office
Can't use Enterprise SQL

fu-sign.com - my asp.net blog

theboss

Posted: Friday, December 28, 2007 5:10:31 PM

Rank: Administration

Joined: 2/10/2007
Posts: 77
Points: 417

then write two queries in following way

select
db server |
insert into
db server ||

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.