Good day, Quick question.....is there any database utility that can be used to connect to the RMS databse, pull the relevant information, and convert it to a CSV or Excel file . Then, after editing the csv or excel file.....convert it back into the RMS database......Any help would be greatly appreciated.....
Best regards, Uttam Dookhran
Excel can connect directly to the database.
SO Admin - Connect - do Query - export to CSV...
To import I use QSCimport - doesn't work on RMS 2.0 - use excel ...
Danny, what does not work in 2.0? I imported a database into RMS 2.0 using QSImport last week and it worked fine.
K> SO Admin - Connect - do Query - export to CSV...
What are you trying do update or change that you want to directly modify the database to handle? We have several utilities available to help with updating pricing etc, without going through all the RMS tabs to do so.
Let me know how we can help you.
Have something to add? Share your thoughts — no account required.
Ask the community — no account required