Date: 03/24/05 (SQL Server)    Keywords: database, sql

Using ONLY T-SQL (a stored proc really), is there a way to gain access to a MS Access DB and pull data out of it into a SQL Server database?

I know one theoretical solution is to create a linked server against the MS Access DB, pull my data out that way, kill the linked server property, and go along my merry way, but there's gotta be a better way to do this!

And no, DTS really isn't an option either I'm afraid.

x-posted to databases

Source: http://www.livejournal.com/community/sqlserver/22438.html