Tables; link, import or ?

  • Thread starter Thread starter Smitty
  • Start date Start date
S

Smitty

a true newby here,
I have created a data base here based on orders in
an excell spreadsheet. My problem is from one day the
next, the info in the spreadsheet changes with new ones
coming in and old completed records dropping off the file.

What is the best way to keep all the information from the
customers while adding new? If I link the table we loose
the old info on past customers so I think the way I
should do this is at the end of a period of time to do a
union query on seperate tables that are based each
spreadsheet not allowing duplicates. Am I headed in the
right direction or can we import or merge the info w/o
allowing for duplicates?

Thanks
 
Smitty,

The first question is... if 'you' created the spreadsheet
for the orders, why didn't/don't you just put the order
tracking into Access. In Access you would store your
customers in their own table and they would be there for the
duration plus it would save you re-entering their info every
time you have a new order. You can now just filter for
current records if you don't want to see the historical
ones.

If you feel you need to use the spreadsheet, I would
consider appending all of the records to a master table in
Access that will keep the whole history. From the "new ones
coming in and old completed records dropping off the file,"
comment, I would think that you will need to handle not
appending duplicate records to this table as it sounds like
some will be there multiple times.

Again, my suggestion is to port the spreadsheet to a proper
relational database design in Access.

Regards,

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 
Back
Top