Interview Questions Answers.ORG
Interviewer And Interviewee Guide
Interviews
Quizzes
Home
Quizzes
Interviews Databases Programming Interviews:BtrieveClipperData ModelingData StructuresDatabase AdministrationDatabase Administrator (DBA)Database AnalystDatabase DeveloperDB DevelopmentEDI/Data Integration ExpertFirebirdHierarchicalIBM DB2InformixJava DatabaseMariaDBMicrosoft Access DeveloperMongoDBMS SQL ServerMySQL ProgrammingNetworkNoSQLObject RelationalPostgrePostgreSQLProgressRDBMSRelationalSQLSQL AdministratorSQL and PL/SQLSQL Notification ServicesSQL server 2008SSRSStored ProcedureSybaseTeradata
Copyright © 2018. All Rights Reserved
MS SQL Server Interview Question:
How To Connect MS Access to SQL Servers through ODBC?
Submitted by: AdministratorOnce you got a DSN defined in the ODBC manager that connects to your SQL Server, you can connect a normal MS Access document to the Oracle server, and link an Access table to a SQL Server table. The tutorial below gives you a good example:
* Start MS Access with a new database file.
* Go to File menu.
* Select Get External Data.
* Select Import.... The Import dialog box shows up.
* Select Files of type: ODBC Database(). The Select Data Source dialog box shows up.
* Click the Machine Data Source tab. You should see the DSN name "ggl_SQL_SERVER" you defined earlier.
* Select "ggl_SQL_SERVER".
* Enter User Name: sa.
* Enter Password: GlobalGuideLine.
Click the OK button to continue. You should see a list of tables available for you to import from the SQL Server as shown in the picture below:
MS Access importing tables via ODBC
Select the table you are interested in and click OK. You should the selected table being imported from the SQL Server to MS Access.
Submitted by: Administrator
* Start MS Access with a new database file.
* Go to File menu.
* Select Get External Data.
* Select Import.... The Import dialog box shows up.
* Select Files of type: ODBC Database(). The Select Data Source dialog box shows up.
* Click the Machine Data Source tab. You should see the DSN name "ggl_SQL_SERVER" you defined earlier.
* Select "ggl_SQL_SERVER".
* Enter User Name: sa.
* Enter Password: GlobalGuideLine.
Click the OK button to continue. You should see a list of tables available for you to import from the SQL Server as shown in the picture below:
MS Access importing tables via ODBC
Select the table you are interested in and click OK. You should the selected table being imported from the SQL Server to MS Access.
Submitted by: Administrator
Copyright 2007-2024 by Interview Questions Answers .ORG All Rights Reserved.
https://InterviewQuestionsAnswers.ORG.
https://InterviewQuestionsAnswers.ORG.