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 |
|
er_stout
Starting Member
3 Posts |
 Posted - 2002-09-26 : 18:20:44
|
| Probably an extremely stupid question, but I'm hoping there's actually an intelligent answer somewhere. I have an SQL table based on UniqueIDwithUPCASE_Alpha; I'd like to build a view linking it to an Access data table based on UniqueIDwithUNSPECIFIED_Alpha (might be an 'h', might be an 'H').Does anyone know whether views can be defined joining Access and SQL tables? Is it worth doing? If so, I'm presuming I can probably force an UPCASEd join.Thanks. |
|
|
DavidD
Yak Posting Veteran
73 Posts |
Posted - 2002-09-26 : 19:23:54
|
| You can link sql server and access easily using an ODBC connection. I usually do it in Access. In access go import data -> link table and then define your connection. After that the table is treated like an ordinary Access table in terms of data manipulation (you can't change the design in Access). To link Access to SQL use sp_addlinkedserver, you access tables are then on a linked server.RegardsDavid |
 |
|
|
|
|
|
SQL and Access Views