Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Getting Data from a non-local sql database

Status
Not open for further replies.
MarkRobinson

MarkRobinson

Programmer
Feb 18, 2000
112
US
The sql server on my website has some data I need.
I realize I can install SQL server on my desktop, download and replicate the database, then import it into excel -- but I'm looking for something simpler such as:

Link to the database at its remote IP address or
Backup the SQL database and 'restore' it into access.

Any ideas?

Thanks!
 
Status
Not open for further replies.

Similar threads

TomSalvato
  • Locked
  • Question
Getting the Monday date from a week number 1
Replies
2
Views
270
TomSalvato
TomSalvato
Xavierparkash
  • Locked
  • Question
MS Access Slow Search in Linked Database
Replies
0
Views
149
Xavierparkash
Xavierparkash
PrimoSteve
  • Locked
  • Question
Grid From 1
2
Replies
21
Views
1K
PrimoSteve
PrimoSteve
ameedoo3000
  • Locked
  • Question
Rename current database
Replies
0
Views
169
ameedoo3000
ameedoo3000
ameedoo3000
  • Locked
  • Question
rename current database 2
2
Replies
31
Views
548
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top