T
Tony Williams
I get a spreadsheet that contains data I need to add to an existing table.
However some of the spreadsheet data is to update cureent records and some is
to be added as new records. I imagined I could do this with two queries an
append query and an update query but I'm not sure how I would get the queries
to work from the import. How do I get the querries to decide if records
already exist? The data is a list of vehicles and the VRM is the unique
identifier, HOWEVER some records don't yet have a VRM so I have a problem of
identifying those records to update where the VRM is not yet present.
Anyone help with suggestions? I'm a VBA novice so if that's the root please
treat me gently!
Thanks
Tony
However some of the spreadsheet data is to update cureent records and some is
to be added as new records. I imagined I could do this with two queries an
append query and an update query but I'm not sure how I would get the queries
to work from the import. How do I get the querries to decide if records
already exist? The data is a list of vehicles and the VRM is the unique
identifier, HOWEVER some records don't yet have a VRM so I have a problem of
identifying those records to update where the VRM is not yet present.
Anyone help with suggestions? I'm a VBA novice so if that's the root please
treat me gently!
Thanks
Tony