469,942 Members | 2,599 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,942 developers. It's quick & easy.

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

Nov 15 '06 #1
5 2561
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
Nov 15 '06 #2

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

How would you do it?

Nov 15 '06 #3
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?

Nov 15 '06 #4
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?
Nov 15 '06 #5
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.

Nov 15 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

19 posts views Thread by davidgordon | last post: by
4 posts views Thread by colmkav | last post: by
4 posts views Thread by christianlott1 | last post: by
7 posts views Thread by franc sutherland | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.