Copy linked tables from Access to Excel

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

re: Copy linked tables from Access to Excel

On 15 Nov 2006 10:46:13 -0800, "erick-flores"
<chunkyflores@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.

re: Copy linked tables from Access to Excel

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

How would you do it?

re: Copy linked tables from Access to Excel

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?

re: Copy linked tables from Access to Excel

On 15 Nov 2006 13:03:11 -0800, "erick-flores"
<chunkyflores@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.

re: Copy linked tables from Access to Excel

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.