Import New and Changed Records in Microsoft Access. Update Pricing from Vendor Excel Spreadsheet

Is there anything we can do if unique ID's are not provided? Iv got many records that have different names yet use the same ID.

Any help is appreciated

all thumbs up before the class even starts. thank you so much Richard for another valuable tutorials 👍

everything is working for me except the update price. no matter what i do i cant get the prices to update. the price review works perfect. any idea on what i am doing wrong?

I wanted to come back here and thank you for helping me with a project I was working on that I was having difficulty with. Having viewed, let's just say, a lot of your videos, this one in particular was very helpful to me.

hi
i have excel table for orders ...how to convert it to access database
you know in access we need tabls of customers, orders, orders detail , shipment and employee to creat the data bass
i dont like to fill that table copy past
what is your recmmndation ..thanks

Hello Sir is it possible to update multiple calculated fields in a continuous form with one click using vba.Thank you

How to update Product prices without loosing the old price recorded in msaccess

This is powerful bro. Thanks

thank you ,

Fantastic video, a silly question ‘query’ I have set up access tables and import tables via excel. However, some of the data will update, is there a way to import and update without linking excel table.

Excellent

Love this. As usual I am looking for yet another little nugget of gold from Richard - and he delivers a treasure trove of extra stuff!

This is fantastic! I do have one question, I am planning to split my database before deploying it to end users. Does it matter if I set up these queries before I split it?

Big help on a project I've been working on. I knew it could be done as I had mastered (*cough* but had forgotten how *cough*) appending. Updating from an Excel spreadsheet was an unknown. If all works out right there will be no more wasting 20 minutes a day had updating my entries. Instead I'll be able to spend the same 20 minutes watching yours and other videos (I so need a life.)

Great explanation, great video — thank you!

Amazing video! Thanks!

Is there a way to identify all the values that is updated through import and track the old value and new value in change log? Appreciate if you could suggest a way.

Awesome video. Thank you kindly.

On the Append side of this video when you are setting your outer limits, is it possible to have the query show stocknumber that aren't equal? I have a similar scenario as the video; however, my "price list" will constantly be adding new products that I'd need to append to my list, and it doesn't always go back to the initial product. There is no cumulative list of all product to reference, infact that cumulative list, is what I'm attempting to create.

why duplicate output destination 'Stocknum"?