Importing data from a remote SQL Server

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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"?
Click to expand...

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? :)
 
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
 
Back
Top