| Author |
Topic |
|
newdba
Starting Member
30 Posts |
 Posted - 2011-06-15 : 09:15:42
|
| how do you link a access database to sql? |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-06-15 : 10:10:24
|
| In Management Studio:- click VIEW- Template Explorer- Expand the Linked Server Node- Double-click Add Linked Server Access MDBThis will give you a template for adding the linked server. |
 |
|
|
newdba
Starting Member
30 Posts |
Posted - 2011-06-15 : 15:42:48
|
| i don't understnad the concept. linked server? can't i just import it into a database ? |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-06-15 : 15:48:33
|
| Well, you asked to link, not import. Which do you want to do? |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2011-06-16 : 01:30:07
|
| Import you can do , it depends how complex the import requirements . The concept of Linked Server is different to Import. The Linked Server allows commnads to be run against data sources on other servers.Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-06-16 : 07:43:54
|
| Where do you want to see the data, access or sql server? Do you have data in the access file that you want to see in sql server or the other way around?- LumbagoMy blog-> http://thefirstsql.com/2011/02/07/regular-expressions-advanced-string-matching-and-new-split-function-sql-server-2008-r2/ |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
|
|
newdba
Starting Member
30 Posts |
Posted - 2011-06-16 : 09:48:39
|
| the data is in the Access Database file and it needs to be seen in SQL |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-06-16 : 09:51:48
|
| you can use SSIS, or the import wizard to quickly get the data into SQL Server. |
|
|
|
newdba
Starting Member
30 Posts |
Posted - 2011-06-16 : 10:04:15
|
| right but can I link it together with access after that? |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-06-16 : 10:29:50
|
| Are you trying to upsize the Access data to SQL Server, and then use linked tables in Access? |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-06-16 : 10:42:17
|
| How about you tell us what you need to do. Then we can help you find a solution. |
|
|
|
newdba
Starting Member
30 Posts |
Posted - 2011-06-16 : 11:36:44
|
| i'm sorry if i sound so confused here is hte email from teh director about the requirements. maybe i'm understanding something wrong?For the project we are doing for Distribution & Repair1) We need an SQL database created, call it DISTRIBUTION2) I have an access database that we need to create links from to this new SQL DB |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-06-16 : 11:47:27
|
| 1. Don't call it Distribution, that's a standard name for SQL Server replication distributor databases. Even if you're not using replication, it's better to avoid any conflict.2. There's a link tables wizard in Access. Create your SQL Server database and tables, then run the wizard. It will walk you through setting up the server connection and linking each table. |
|
|
|
newdba
Starting Member
30 Posts |
Posted - 2011-06-16 : 13:23:49
|
| create the database and import the tables thru SSIS shud be fine right? then do the link tables wizard? |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-06-16 : 13:41:04
|
| Yes, that works too. |
|
|
|
|
linking a sql database to access