On Tue, Mar 31, 2009 at 9:57 AM, mz <mz@infomagic.net> wrote:

I'm migrating from M$ WinXP to openSUSE 11.0. At the moment I'm looking
for a db for simple personal use.

I have a music collection db in M$ Access. There are about 1900 records
w/ six variables. The collection is mostly vinyl LPs (i.e., entered by
hand) with another 2000 LPs not yet in the db. If possible, I'd like
to do a simple import w/ minimal clean up to avoid re-entering the
existing records.

What are the recommendations for a db and how best to accomplish the
migration?

TIA,
Mark Z.
---------------------------------------------------
PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change your mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss

> how best to accomplish the migration?

Even M$ Access can output ("export"?)

data in the format of a CSV file, right?

(comma separated values)

That should be all you need, to "import"

to your destination db -- MySql or whatever.

And (IANA Db admin, but) I think any good db

should be able to "import" a CSV file (right?)

...if not, then you might want to get a

"second opinion", on the

> recommendations for a db

just my 0.02 ...

--
Mike Schwartz
Glendale AZ
schwartz@acm.org