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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

linking tales

Status
Not open for further replies.
dvannoy

dvannoy

MIS
Joined
May 4, 2001
Messages
2,765
Location
US
Is it possible in SQL server to link a table to a DBASE file?? i have a app in access that i will be converting to SQL 2000 server. and in that app I link a table to a DBASEIII file. will that still be possible?

Thanks DVannoy
A+,Network+,CNA
dvannoy@onyxes.com
 
Sort by date Sort by votes
SQL Server can certainly access a DBASE table using OLE DB for ODBC. I don't know the ramifications of linking to an Access .MDB that has attached DBASE tables but I suspect it will work.
 
Upvote 0 Downvote
One way to do it, is to set up the remote server under linked servers...

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

rwn
  • Locked
  • Question Question
Adding a New Table/Field and Linking
Replies
5
Views
270
gmmastros
gmmastros
gbaughma
  • Locked
  • Question Question
Linking servers on the fly in a SP?
Replies
12
Views
282
gbaughma
gbaughma
adanny08
  • Locked
  • Question Question
Linking two databases
Replies
1
Views
85
hmckillop
hmckillop
johnisotank
  • Locked
  • Question Question
COUNT is wrong when linking 2 tables
Replies
7
Views
168
johnisotank
johnisotank
awholtsIT
  • Locked
  • Question Question
Linking inventory master table to sales order history
Replies
2
Views
102
gmmastros
gmmastros

Part and Inventory Search

Sponsor

Back
Top