Copy linked tables from Access to Excel

[erick-flores]

Hello all

I have 4 tables in MS Access 2003. I want to export all these tables,
with their links, to Excel. How do I export them with all the link
between tables....can I do that? I know I can export the tables to
Excel but I dont know if the links will export too

Any ideas? Thanks in advance

[Tom van Stiphout]

On 15 Nov 2006 10:46:13 -0800, "erick-flores"
<ch**********@hotmail.comwrote:

"...with their links..."?
Do you mean you have relationships between tables (e.g. from Customers
table to Orders table) and you want those exported as well?
Think about it: how would such relationships manifest itself in Excel?

-Tom.

>Hello all

I have 4 tables in MS Access 2003. I want to export all these tables,
with their links, to Excel. How do I export them with all the link
between tables....can I do that? I know I can export the tables to
Excel but I dont know if the links will export too

Any ideas? Thanks in advance

[erick-flores]

Yeah, thats what I mean. I dont know, thats why I am asking...

How would you do it?

[erick-flores]

Do you think its a good idea to create a table using a query that will
get all the information from my tables together and then export it to
Excel?

[Tom van Stiphout]

On 15 Nov 2006 13:03:11 -0800, "erick-flores"
<ch**********@hotmail.comwrote:

You have to understand some fundamental differences between Access and
Excel. One of them is: in Access you can enforce referential integrity
(RI), in Excel you cannot. If IR is important to you, you know where
to store your data.
You're then free to export some data to Excel
(Docmd.TransferSpreadsheet) and take advantage of what Excel is good
at.

-Tom.

>Do you think its a good idea to create a table using a query that will
get all the information from my tables together and then export it to
Excel?

[erick-flores]

Thank you. I do understand the fundamental of each one, I was just
wondering about my first post. Now I created a make-table query and got
all the data that I wanted in just one table. Now I can export it to
Excel w/o problem.