By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,333 Members | 1,850 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,333 IT Pros & Developers. It's quick & easy.

Copy linked tables from Access to Excel

P: n/a
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
Share this Question
Share on Google+
5 Replies


P: n/a
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

P: n/a

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

How would you do it?

Nov 15 '06 #3

P: n/a
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

P: n/a
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

P: n/a
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.