Import utility for .csv/.xls data into RMS?

Hello:
I have recently been tasked with administering the database of several
systems at work including Microsft RMS. I see there is a native export
feature in the admin utility to draw data out of the SQL DB, but no such
Import feature.
I have a csv of several hundred Customer's I would like to bulk import into
RMS.
Is this QS import utility able to do that? If so, where would you get it?
thanks!
Reply to
Mark
Mark,
If your company is on a Maintenance program you can login to the CustomerSource website and download it from there. And yes it can import your csv file.
Rob
Reply to
Robert
Rob:
glad to know it is out there, I will have to check my company's MS contract. This is for small museum at which I only work 2 days a week. Their RMS installation was done year's ago by a now defunct company. Are there any other options for bulk importing data into RMS?
thanks! Mark
Reply to
Mark
Mark,
You can try the EMS SQL Import tool it is $39 US.
formatting link
a.. Importing from six most popular formats: MS Excel, MS Access, XML, DBF, TXT and CSV a.. Importing data to several objects from different databases on one host a.. Importing data from tables and views a.. Adjustable import parameters for each source file a.. Possibility of saving all the export parameters, set on current wizard session a.. Command-line utility to export data using the configuration file
Rob
Reply to
Robert

Site Timeline Threads

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.