Open MS Access and Create Database:
Click on External Data tab n click on More Click ODBC Database which shows this Wizard
select Link to data source..... and click OK:
Click New (leave this DSN empty Ignore tester in above image ) :
Select SQL SERVER and Click Next: then Browse
Write DSN filename(like tester)
on server: Dropdownlist select your sqlsever name or simply open sqlmanagement n copy paste its server name here as shown in images:
select database like Pizzanext from database after clicking on check box:
here i have selected town table for generating report and my Town table is available in MSACCESS
"Share your Knowledge!!"
If you like Please Don't forget to Comment.