Importing linked tables

[moto]

Hi guys

I've been given a project at work, part of which involves importing parts of a very complex SQL database in to an Access 2002 database. This is very much on the edge of my understanding of databases, so please bear with me!

All of the records I need to import are in one table, but some of the fields are linked to other tables in the SQL server. My question is, if I import the table in to Access using Get External Data/Import, will the information from the linked tables also be imported, or will I also have to import the linked tables and re-establish the link between the tables in Access?

Thanks in advance for any advice

--
moto

 

[statsman]

I am probably going to get dumped on by other experts for this one but,

What I have always done is export all of the tables into a new folder on my hard drive in Excel format.

I then create an Excel spreadsheet that has all of the necessary data in it (and none that is not required).

I then import the speadsheet into Access as a new table.

You did not mention if the files in SQL need to be updated when you update them in Access? If they do, don't use this method.

 

[Robert88]

Hi Moto,

If you have linked tables in your access, this provides a link directly to the SQL table, so any changes via editing in your Access application will then directly change the data in the SQL tables.

To check to see if they are linked goto tables tab in your mdb and if there is an arrow pointing toward the table name, it is a good chance it is linked.

By importing it, this means that any changes made to the imported data will not reflect into the SQL table as it will then only be contained within Access.

Sound like you might want to do some reasearch on linked tables? Depending on what you are trying to achieve?

I hope this helps?

Robert88

 

[moto]

Thanks for the replies guys. I do not want the data on the SQL server to be updated when I update Access. That's why I imported the data as a new table in Access rather than linking directly to the SQL server.

The tables on the SQL server are linked to each other. I just want to make sure that by importing the "main" table which links to the others, that all of the data from the tables to which the main one is linked will also be imported.

Hope that's a bit clearer

 

[neileg]

The tables on the SQL server are linked to each other. I just want to make sure that by importing the "main" table which links to the others, that all of the data from the tables to which the main one is linked will also be imported.

If you import one table, you get one table. If you want the data in the linked tables you'll need to import them as well.

 

[Robert88]

Hi moto,

I suppose once all tables have been imported, any relationships amongst tables have to be re-established.

Good Luck with it.

Robert88