Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mbevon
Starting Member
41 Posts |
 Posted - 2002-07-16 : 10:04:10
|
| Could you please provide me with an example of accessing a table on the SQL server and then executing a Select *, from microsoft access 2000.thanks |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-07-16 : 10:38:05
|
| In Access, go to File/Get External Data. When the file window comes up, look at the last dropdown box under File Type. Select the last option, ODBC Data sources. From there, follow the instructions of the wizard to select a SQL Server source. Fill out the SQL Server name and use the appropriate login and password. Make sure to select the correct database you want to query. When you get to the end there will be a button to test the data connection, make sure it connects properly, and then hit OK.Once that's done you'll have a new Data Source Name (DSN) that allows you to connect to the SQL Server. Continue with the process, selecting the DSN you just created. You'll get a list of the available tables, highlight all of the ones you need and then hit OK. Access will create linked tables, and you can use them exactly as if there were native Access tables.Look in the MS Access help file for more information on linked tables. |
 |
|
|
|
|
|
Access 2000 to SQl 2000