Logo
amrit software
 Denver, Colorado
Create an ODBC Datasource Link Tables in Access 2007 Export to Excel in Access 2007
How to Create an ODBC Datasource
To connect to SQL Server tables you will need an ODBC datasource.
Step 1: Start Select Data Source dialog
In the Select Data Source dialog click on the New... button.
Step 2: Select driver Select driver
The select driver list box appears. Select SQL Sever and Click the Next > button.
Step 3: Enter a name Select driver
Type a name for the datasource file and Click the Next > button.
Step 4: Finish Finish
Click Finish to create the datasource.
Step 5: Enter server name or IP address Enter server name/ IP address
Create datasource for SQL wizard opens. Enter a description for the datasource. Enter the name or IP address of the server the SQL Server database is on. For a database on the same computer database enter "(local)". Click the Next > button.
Step 6: Enter login information Enter login information
In the authentication dialog select "With SQL Server authentication." option. Enter the Login ID and Password for the SQL server database. Click the Next > button.
Step 7: Enter a data source name Enter a data source name
Check the Change default database to checkbox. Select the database name from the dropdown list. Click the Next > button.
Step 8: Finish Finish
Click the Finish button.
Step 9: Test connection Test connection
The ODBC Microsoft SQL Server Setup Test page appears. Click on the Test Data Source... button. If the data source was set up correctly, you will see the TESTS COMPLETED SUCCESSFULLY! message.
Step 10: Complete Complete
Click the OK button. Click the OK button on the Test page also. The new data source will now apppear in the Select Data Source dialog.
Step 11: New data source New data source
The new data source will now appear in the Select Data Source dialog. You are ready to link tables now.
Home  |  Software  |  Projects  

Amrit Software LLC, 5753 S Kearney St., Greenwood Village, CO 80111, United States
Phone: (303) 771-5949