Hello,
I have an access database that one of the table column's data needs to be updated. There is existing data in this column, but there are a lot of empty cells previously. I need to update those empty cells now with the new data that I have in an excel spreadsheet. There is about 30k total records and I have to update about 9k.
Is there a way to upload the new data into this table column (only empty cells) while keeping the existing data for other records? The data in the excel spreadsheet contains 2 columns. The first column is the name of company and the second column is a set of numbers like order receipt number (9 digits) that corresponds to the matching company name. I need help importing the second column into the Access database, but only to the empty cells matching the company name without replacing/deleting any data for other records.
Data from this table comes from a front-end form that staff would use. The second column (order receipt number) would be entered at a different time, but it was forgotten when the staff left the company. I'm sort of new to Access DB, so any help is greatly appreciated. Any questions or need more detail, feel free to let me know!!
Thanks,
Carmen
I have an access database that one of the table column's data needs to be updated. There is existing data in this column, but there are a lot of empty cells previously. I need to update those empty cells now with the new data that I have in an excel spreadsheet. There is about 30k total records and I have to update about 9k.
Is there a way to upload the new data into this table column (only empty cells) while keeping the existing data for other records? The data in the excel spreadsheet contains 2 columns. The first column is the name of company and the second column is a set of numbers like order receipt number (9 digits) that corresponds to the matching company name. I need help importing the second column into the Access database, but only to the empty cells matching the company name without replacing/deleting any data for other records.
Data from this table comes from a front-end form that staff would use. The second column (order receipt number) would be entered at a different time, but it was forgotten when the staff left the company. I'm sort of new to Access DB, so any help is greatly appreciated. Any questions or need more detail, feel free to let me know!!
Thanks,
Carmen