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

Integrating several Excel spreads into Access

P: n/a
Okay, here is my problem and understand I have little experience with
Access.

I am trying to integrate 3 spreadsheets into Access. Each spread
sheet is about 50 legal pages in size and are linked by a persons
name. What I need is a way to do this enormous task.

Here is an idea of what I have, Spreadsheet 1 looks like;

A1 B1
Place Person

Spreadsheet 2;

A1 B1 C1 D1 E1
Place Person Address Phone Contact

Spreadsheet 3;
A1 B1 C1-N1
Place Person Value1
Value2
Value3
Total

I would like to have it so that a change in the person would be
reflected on printouts of data contained in all 3 spreadsheets.
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
It is unclear what you mean when you say 3 spreadsheets, each sheet is
about 50 pages in size, and you want to display changes in the
printouts.

It sounds like you have one workbook with 3 sheets. How many rows of
data are there in each sheet? When you update a row of data you want
that to show up when you print the sheet out to the printer? Where are
you updating the row? In Excel?

Sometimes the anser to your question is in the way you ask the question.
If you have 3 sheets of data in an Excel workbook, and you have
thousands of rows of data, I would import that data to Access Tables.
Then you could create a query to filter the data in Access and cut and
paste straight from the query to Excel with just the records you need to
see/print out.

Rich

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #2

P: n/a
jh*********@yahoo.com (Jason H) wrote in message news:<7f**************************@posting.google. com>...
Okay, here is my problem and understand I have little experience with
Access.

I am trying to integrate 3 spreadsheets into Access. Each spread
sheet is about 50 legal pages in size and are linked by a persons
name. What I need is a way to do this enormous task.

Here is an idea of what I have, Spreadsheet 1 looks like;

A1 B1
Place Person

Spreadsheet 2;

A1 B1 C1 D1 E1
Place Person Address Phone Contact

Spreadsheet 3;
A1 B1 C1-N1
Place Person Value1
Value2
Value3
Total

I would like to have it so that a change in the person would be
reflected on printouts of data contained in all 3 spreadsheets.


Table1: PersonPlaceID, Person, Place
Table2: PersonPlaceID, Address, Phone, Contact
Table3: PersonPlaceID,C1-N1

If you want totals, use a report or a query, NOT in a table, unless
there's a damned good reason for it.
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.