MS Access and connecting to an ODBC connection
I have established an ODBC connection to a sql server. What I would like to do now is be able to access the data using MS Access. How do I go about starting the Access database and getting all the table information out of the sql database? There seems to be no definitive answer using Google. I would just like (if possible) a step by step "How To" explanation so that I can look at all the tables in the db and then do myh own queries. As always your help is appreciated. Hoping Jeffbx,DF and others respond if you have an answer or can point in the right direction.
So you have the ODBC part already completed?
Ok, let's see if this can get you pointed in the right direction:
[list=1][*]Create (or Open) your Access database[*]Go to File -> Get External Data -> Link Tables[*]In the "Files of type" combo box, choose ODBC Databases()[*]Choose your ODBC Data Source[/list=1]
I've done this before, but it has been a long time. Someone out there with a little more experience with this might have a better suggestion for you. But it can't hurt to try, right?
I dunno, databases aren't really my strong point. However, you can find pretty much everything you need to know right here.