tmroenicke
asked on
Updating existing Pervasive Database entries from an Excel sheet
We have a pervasive database with all of our inventory order, reorder, and quantity ect.
I have an excel sheet with updated quantities of these 9,500 parts. Is there any programs that anyone is aware of that will take and generate "SQL Scripts" in this case UPDATE scripts based on this information, or is there a way to script it myself?
I have an excel sheet with updated quantities of these 9,500 parts. Is there any programs that anyone is aware of that will take and generate "SQL Scripts" in this case UPDATE scripts based on this information, or is there a way to script it myself?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER