Clever Geek Handbook

Help with accessing sql 2007 tables?

Does anyone know where in Access 2007 there is a function where I can access my sql database? I need to create reports. thank

0


source to share


2 answers


Create an ODBC connection. In Microsoft Access, go to the File menu and select Get External Data and select Reference Tables ... from the menu that appears.



+2


source


As with linked tables, as suggested by ocdecio, you can also run the "Access Database Project", which is basically a SQL end access interface. If you did it this way, you could use all the existing views, stored procedures, functions, etc.



+1


source






More articles:


All Articles