Importing data from a remote SQL Server

[natasha]

Good evening,
I've an ASP.NET 2.0 web site in hosting, with data collected in a remote SQL
Server.
Now, I've to import collected data in a desktop Access application.
Can anyone suggest me how to do?

 

[Jeff Boyce]

Natasha

Are you absolutely convinced you have to "import" data? Once you've done
so, your data (in Access) is suspect, because it is no longer synchronized
with the source (SQL-Server) data.

Will your situation allow for a "link" rather than an "import"?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[natasha]

Are you absolutely convinced you have to "import" data? Once you've done

so, your data (in Access) is suspect, because it is no longer synchronized
with the source (SQL-Server) data.

Will your situation allow for a "link" rather than an "import"?

Hello Jeff,
data on remote SQL Server are orders. Of course I need and import on a
periodic basis, but once they've been collected, they're subject no more to
changes, on remote side.
Anyway, should I "link" or "import".... how to do it?

 

[Jeff Boyce]

Natasha

I think I overlooked the "remote" part of your earlier post. Access has had
some difficulties connecting to remote dbs. Try checking mvps.org/access
for some leads to techniques used to connect over Wide Area Networks (WANs).

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[A a r o n K e m p f]

you need A c c e s s D a t a P r o j e c t s