Is there a way to get access to an Access table????

Question

Is there a way to get access to an Access table????

cedar72

Say Hey Kid

Points: 711
More actions
June 23, 2005 at 10:11 am

#89627

Is there a way to get access to an Access table through t-sql? I really don't want to always have to DTS the data

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

Create a linked server to the database, then query like this

Select * from LinkedServerName...TableName (play with the number of dots if it doesn't work... never did that with access).

cutespn SSCommitted Points: 1669 More actions · Answer 2

Yes u can created a linked server to access and use it .

Check this out:

http://www.databasejournal.com/features/mssql/article.php/3085211

http://www.informit.com/articles/article.asp?p=360063&seqNum=1

Regards,
Sudheer

noeld SSC Guru Points: 96590 More actions · Answer 3

BTW is always Three dots for MSACCESS. If the DB uses workgroup protection you may need further help(let me know) but if it is not you should be OK with the above

* Noel