Hi Jeff, good morning.
I apologize to give you this trouble.

We have 2 teams (pricing and sales) and they want to make sure
whenever an user updates its individual spreadsheet that it will reflect to
DB in access or any other suggestion.
There are specific fields in the spreadsheet that must not be seen by sales
team.

Just to give you an idea... the pricing team (4 people) will feed their
individual spreadsheet and the sales team will check for prices anytime a
customer asks for.

I am an infrastructure guy in the company and we hv no developers in here...
that's why I am lost with this case.

Was I clear? Could I clarify the idea?

Thank you,
MaurÃ*cio

"Jeff Boyce" escreveu:

Mauricio

You may be running up against the difference between Excel (*a spreadsheet*)
and Access (*a relational database*).

In Excel you might just add another column to get another piece of data in
the spreadsheet.

In Access, doing the same thing (adding another field in a table) would NOT
be the correct way to handle the situation. Among other reasons, you'd have
to modify your queries, your forms, your reports, your code, ... every time!
What a maintenance nightmare!

Perhaps if you post a bit more information about just what it is that you're
importing/linking, folks here could offer more specific suggestions.

For example, if you are working with "monthly" values (and just adding
another month in Excel), you'll need to rethink how you structure your data
in Access if you wish to get full use of the relationally-oriented
features/functions in Access.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"MaurÃ*cio Paiva" wrote in message
...
Hi Jeff.
in fact I had to create the table before creating the excel links.
and You are right... it worked fine.

The problem now is query doesn't allow the table to be updated... I have
to
run it everytime to reflect to table.

For example:
I added new fields to the spreadsheet and the link into excel was updated
but not the new table with all info.
How can I do this real-time?

Thanks a lot!

"Jeff Boyce" escreveu:

Did you first create the new table?

Regards

Jeff Boyce
Microsoft Office/Access MVP


"MaurÃ*cio Paiva" wrote in
message
...
Jeff,
the idea with the queries is great... however when I try to append I
can
see
only the other excel lilnks... it doesn't show me that new table a
create
with the fields only.
Is there any trick?

MaurÃ*cio

"Jeff Boyce" escreveu:

Mauricio

You have four linked 'tables' in Access.

Create a new table (empty) that is defined as needed.

Create a query that returns all the records from one of your four
linked
tables. Open that query in design view and modify it to be an append
query.
Append field (values) from your linked table to your permanent table.

Modify the query to "point" at a different linked table and append
that
table's records.

Repeat until finished.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"MaurÃ*cio Paiva" wrote in
message
...
Yes Jeff.
Actually I meant these 4 linked tables into one.
Can you pls instruct me how to create a query?

I tried some other functions but I always receive a message saying
that
tables are linked from excel and some actions could not be
performed.

Tks,
MaurÃ*cio

"Jeff Boyce" escreveu:

Mauricio

When you say "merge these 4 tables", do you mean actually put the
data
from
each of the four sources into a totally new table?

An alternative to this would be to use a query to collect all of
the
data
in
the same place, and use that as the source for the form.

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP


"MaurÃ*cio Paiva" wrote in
message
...
Hi!
I have 4 spreadsheets that are filled by 4 different users.
I am not an expert in Access but I created a Database and linked
all
of
these 4 spreadsheets into table section. (I Have: CA1, CA2, CA3
and
CA4)
Now I am trying unsuccessfully to merge these 4 tables in order
to
create
only one form.
Can anybody help me with this?

Thanks a lot.
MaurÃ*cio