G
Guest
Hi
Perhaps one of you good people will be able to help me.
I import order details from our order system into an Access database table,
this is quite simply an extract from Crystal saved to Excel format and
imported into the relevent table.
My problem is the Order Number is unique and thus acts as the primary key
field - not allowing duplicates, hence only new orders are imported. This
works fine until an exsisting order details are edited in the order system -
the extract reflects the changes against the original order number (the
unique identifier) but the import is rejected as the unique reference quite
rightly does not allow duplicates - unfortunatly the updated details specific
to the order number are not imported.
I have considered importing into a new table (deleting all current records
on import)
then running an update query that matches the unique order reference and
updates all detail fields from the new table to the Order table.
This works but is there a better way of doing this directly from the import?
And most importantly because there are many orders how can I easily identify
which records have been updated from their original value????? I am only
interested in the records where values have actually changed - not the
records where the updated value remains the same as before. Is it possible
to chaNge the text colour where values have changed after updating ??????
Appreciate any help/suggestions on this matter
Kind Regards
GARMANI
Perhaps one of you good people will be able to help me.
I import order details from our order system into an Access database table,
this is quite simply an extract from Crystal saved to Excel format and
imported into the relevent table.
My problem is the Order Number is unique and thus acts as the primary key
field - not allowing duplicates, hence only new orders are imported. This
works fine until an exsisting order details are edited in the order system -
the extract reflects the changes against the original order number (the
unique identifier) but the import is rejected as the unique reference quite
rightly does not allow duplicates - unfortunatly the updated details specific
to the order number are not imported.
I have considered importing into a new table (deleting all current records
on import)
then running an update query that matches the unique order reference and
updates all detail fields from the new table to the Order table.
This works but is there a better way of doing this directly from the import?
And most importantly because there are many orders how can I easily identify
which records have been updated from their original value????? I am only
interested in the records where values have actually changed - not the
records where the updated value remains the same as before. Is it possible
to chaNge the text colour where values have changed after updating ??????
Appreciate any help/suggestions on this matter
Kind Regards
GARMANI