Hi I have a CSV file with all my data to be imported to SQL database of RMS. I have downloaded trial version "EMS Data Import for MySQL". It seems that I need to have a blank SQL database already created to import my CSV file data. How could I create a blank SQL database? Is this the way it is suppose to work or am I missing something. Thanks Don Watane
Import CSV to SQL database
Jan 14, 2006
2 Replies
Don,
Nope, you're not missing anything. MSImport needs a database to import into.
To create a new one, SO Administrator | File | Connect | put your password in | Database | Create | give it a name | Next | when it asks for a file, click on the magnifying glass, double click on the DBFiles folder, then double on the rmsdb.bck | Next | Next | Finish
You have now created a new blank RMS database. Now connect to it.
File | Connect | put your password in and change the name of the database to what you just created | File | Configuration | change the db name here too. | Test Connection
Exit Admin. Now go back to MSImport and give it the name of the new database you created and the password.
The demo version will only import 5 records I think, unless they've changed it.
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required