Dustin Stanley
asked on
MS Access Query Help With Updating Information To Specific IDs Criteria
I need help with an update query as I want to get it right so I don't mess up the wrong IDs.
BackStory:
I had an old Database Software that was horrible. I exported everything out of it as a CSV file into Excel.
When I did this in the Column SkuUPC (UPC Codes) Excel messed them all up and turned them into things like this "4.02E+12".
I used that saved CSV file to create my new database and I have 1000's of these messed up UPCs.
My original database had IDs (DDMS3ID). I exported those IDs and made a new field in my new database in the SKUs Table called "DDMS3ID".
I know I can do an update query to say hey update SkuUPC to this new UPC where DDMS3ID = DDMS3ID. But I am not 100% sure how to do this and don't want to mess everything up.
Tables invloved:
SKUs
Fields Involved:
SkuUPC
CSV File from Old Database with original Unmessed up UPCs.
Thanks.
BackStory:
I had an old Database Software that was horrible. I exported everything out of it as a CSV file into Excel.
When I did this in the Column SkuUPC (UPC Codes) Excel messed them all up and turned them into things like this "4.02E+12".
I used that saved CSV file to create my new database and I have 1000's of these messed up UPCs.
My original database had IDs (DDMS3ID). I exported those IDs and made a new field in my new database in the SKUs Table called "DDMS3ID".
I know I can do an update query to say hey update SkuUPC to this new UPC where DDMS3ID = DDMS3ID. But I am not 100% sure how to do this and don't want to mess everything up.
Tables invloved:
SKUs
Fields Involved:
SkuUPC
CSV File from Old Database with original Unmessed up UPCs.
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Yes, but are you going to remember to NOT open .csv files by double clicking? Always open unfamiliar .csv files by using the Data/import method to be safe. Once you know what data a file contains and are certain that it doesn't contain any long numbers or "numeric" codes with leading zeros such as Zip and SSN, then you can use the shortcut but until then, better to be safe than sorry.
you're welcome ~ happy to help
you can Open them to look -- just don't Save!
you can Open them to look -- just don't Save!
True but nobody remembers to NEVER SAVE so it is best to use the correct technique when working with unknown files.
ASKER