Import CSV to SQL database


D

Donwatane

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
 
Ad

Advertisements

J

Jeff

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.
--
*
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
 
Ad

Advertisements


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

Similar Threads

Import CSV 3
Import CSV 1
Importing/Transaction/CSV 0
cannot import csv 3
Importing .csv files 3
Import CSV file 1
Import CSV file 1
Importing a CSV file 5

Top