October 28, 2009 at 5:48 pm
Hello Everyone,
I'm definitely a novice when it comes to this type of stuff so please forgive my ignorance.
I'm in a situation where I'm using SQL Server to query off of my work's central reporting DB to perform analyses. I've setup a number of MS Access DBs over the years and have generated a number of coding / translation tables to help with my analyses. Here's my problem: I'd like to call on the MS Access DBs (and associated tables) in my queries using MS SQL Server Query Analyser. I've got as far as setting up the approrpaite Access database as a System DSN - I thought that this would help me either 'import' the DB into my SQL Server queries, or at least call on the relevant tables. I can't figure out how to do this. Any help would be greatly appreciated, and please let me know if my question requires more information to make it easier for anyone out there to provide a solution
Thanks and Kind Regards,
Nik
October 28, 2009 at 8:36 pm
Looks like you need to setup linked servers to your Access databases. You can find more information about those in BOL 9Books Online, the SQL Server Help System). Take some time to read up on them, and then ask any questions you may have.
One thing I will tell you, after you setup a linked server, you query the tables like this:
<linked_server_name>...<table_name>
October 28, 2009 at 8:39 pm
Thanks,
I wasn't even sure what type of information I needed to start researching so now I have bit more of an idea. thanks
Nik
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply