darkroast
Member
This may not be possible, but...
I have a list with 8 elements:
From time to time I get updates to some of those fields in a CSV file. Every line in the update includes the primary key (of course), and Add1-3, city, state, and tech_zip. BP Number never comes in the data included in the CVS.
What I'd like to do is import the file, updating the fields add1, add2. add3, city, state, and tech_zip - but leave alone the BP number.
What happens - at least the way I'm doing it - is that everything for that EUZIP gets updated - but since BP Number isn't in the file, it empties that field.
Any thoughts on how I could run this, short of dumping the table, and doing some kind of vlookup to get the BP Number from the original into the update file?
I have a list with 8 elements:
- EUZIP (this is the key field)
- Add1
- Add2
- Add3
- City
- State
- TECH_ZIP
- BP_NUMBER
From time to time I get updates to some of those fields in a CSV file. Every line in the update includes the primary key (of course), and Add1-3, city, state, and tech_zip. BP Number never comes in the data included in the CVS.
What I'd like to do is import the file, updating the fields add1, add2. add3, city, state, and tech_zip - but leave alone the BP number.
What happens - at least the way I'm doing it - is that everything for that EUZIP gets updated - but since BP Number isn't in the file, it empties that field.
Any thoughts on how I could run this, short of dumping the table, and doing some kind of vlookup to get the BP Number from the original into the update file?