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


M

Mark

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!
 
Ad

Advertisements

R

Robert

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
 
M

Mark

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
 
Ad

Advertisements

R

Robert

Mark,

You can try the EMS SQL Import tool it is $39 US. www.sqlmanager.net
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top