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 |
|
PeterG
Posting Yak Master
156 Posts |
 Posted - 2002-02-11 : 14:22:06
|
| Is this possible? What about importing SQL Server DB to access? |
|
|
JustinBigelow
SQL Gigolo
1157 Posts |
Posted - 2002-02-11 : 15:04:15
|
| Peter, You can view SQL Server data from Access in two ways:1. Linked tables, this is your only option if you are running Access 97 or below.2. Access Data Project, you can do this if you are using Access 2000 or XP. The help files for Access can give you more info on either solution.You cannot import tables from SQL Server, they are totally different beasts. The linked table solution I mentioned is more similiar to importing than the ADP solution is.hth,JustinEdited by - justinbigelow on 02/11/2002 16:37:35 |
 |
|
|
nlocklin
Yak Posting Veteran
69 Posts |
Posted - 2002-02-11 : 16:28:42
|
| You can also use the DTS Import/Export wizard to export a copy of the tables in your SQL Server database to an Access database (if you're looking for a way to copy the tables to an Access database such that they aren't linked to the actual DB on SQL Server).--"I'm always doing that. I'm always messing up some mundane detail." |
|
|
|
|
|
|
Viewing SQL server database from Access?