M
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"??
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"??