importing data from excel

[Marsjune]

Hey I am new here I am sorry if I am about to confuse you But I need some
help and I cant figure this issue out. I am creating a table in access. The
data I need is in several different excel files. all structured the same.the
only thing that will change it the location of the item. I want to import
them into a table. Simple. Here is the issue. I have a field that contains
the location of a item. I am creating a table and I want the default location
to be "x" . When I bring in these excel files I want to up date the the
location in the table only if the location is other than. "X" location

Example: I have 1 spread sheet that several people keep copies of it on PDA.
they are not sync'd up to one file. I have a db and these excel file update 1
table.When we do inventory they update their pdas. now I need to take these
different worksheet and update my table. But I only need to update the
location. of the item. I have set the default location to "x"on the master
spreadsheet. When I import the excel files. I want to update the new location
where the item were found at. So bill goes and does his invatory and update
his pda with locations. and jill does the same now I have to merge and update
these files into my db.and update my tbl. I dont know how to bring in the
different files and update the location of the inventoried items from
multiple users. When I try update or appends Bills file it works.It updates
the tbl with where bill found items. When I bring Jills it over writes bills
information. So now Bill says item "A" was at store 1 When I bring in Jills
information it changes the location of bills Item "A" back to the default
location of "x" How do I get it only to update the location if it not at "x"??

 

[Keith Wilby]

Hey I am new here I am sorry if I am about to confuse you But I need some
help and I cant figure this issue out. I am creating a table in access.
The
data I need is in several different excel files. all structured the
same.the
only thing that will change it the location of the item. I want to import
them into a table. Simple. Here is the issue. I have a field that
contains
the location of a item. I am creating a table and I want the default
location
to be "x" . When I bring in these excel files I want to up date the the
location in the table only if the location is other than. "X" location

Example: I have 1 spread sheet that several people keep copies of it on
PDA.
they are not sync'd up to one file. I have a db and these excel file
update 1
table.When we do inventory they update their pdas. now I need to take
these
different worksheet and update my table. But I only need to update the
location. of the item. I have set the default location to "x"on the master
spreadsheet. When I import the excel files. I want to update the new
location
where the item were found at. So bill goes and does his invatory and
update
his pda with locations. and jill does the same now I have to merge and
update
these files into my db.and update my tbl. I dont know how to bring in the
different files and update the location of the inventoried items from
multiple users. When I try update or appends Bills file it works.It
updates
the tbl with where bill found items. When I bring Jills it over writes
bills
information. So now Bill says item "A" was at store 1 When I bring in
Jills
information it changes the location of bills Item "A" back to the default
location of "x" How do I get it only to update the location if it not at
"x"??

I suppose it is possible to do that but why bother when Access is a much
better tool for the job? I'd suggest setting up a multi-user Access
application for Bob and Jill and whomever else to input their data directly
and cut Excel out of the equation completely. You can even set it up such
that each user can only see their own entry if the data is sensitive.

Just my 2p worth.

Keith.
www.keithwilby.com

 

[Guest]

I am trying to get it in to access. but for now excel works for recording the
info on the location of items. I just need to merg it all together in one