If you like right click solutions for importing then you can also check out Aqua Fold Data Studios. It has a limited trial but it makes things easy as you can connect up to your MS Access db and export the entire database (table creation, caned queries, and data) with just a few clicks. Recreating in MySQL becomes just as easy. If you can have both MySQL on SuSE running and MS Access on win xp, then I would, personally, use access to to directly transfer the data. It's easy and you can immediately verify everything is how you want it so their are no surprises. Otherwise you can export each table as a cvs file and import them using one of the MySQL admin apps (or command line) or you can use AFDS to do everything for you. No matter what you choice to do I would still back up the tables as CVS files and toss them on a jump drive, just in case. _____ From: plug-discuss-bounces@lists.plug.phoenix.az.us [mailto:plug-discuss-bounces@lists.plug.phoenix.az.us] On Behalf Of keith smith Sent: Tuesday, March 31, 2009 12:31 PM To: Main PLUG discussion list Subject: Re: looking for db recommendation If you install and use PhpMyAdmin you can easily import a CSV I assume you can export from access in that format. I searched on "import CSV into mysql" and found a few sites that looked helpful. You would be doing so on the command line if you follow these tutorials. Search this page for CSV http://dev.mysql.com/doc/refman/5.1/en/load-data.html and you will see the following. LOAD DATA INFILE can be used to read files obtained from external sources. For example, many programs can export data in comma-separated values (CSV) format, such that lines have fields separated by commas and enclosed within double quotes. If lines in such a file are terminated by newlines, the statement shown here illustrates the field- and line-handling options you would use to load the file: LOAD DATA INFILE 'data.txt' INTO TABLE tbl_name FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n'; --- I hope this helps. ------------------------ Keith Smith --- On Tue, 3/31/09, Jerry Davis wrote: From: Jerry Davis Subject: Re: looking for db recommendation To: plug-discuss@lists.plug.phoenix.az.us Date: Tuesday, March 31, 2009, 12:02 PM On Tue, 31 Mar 2009 10:29:21 -0700 Mike Schwartz wrote: > On Tue, Mar 31, 2009 at 9:57 AM, mz 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 ... postgresql or mysql would be my choice. i'm sure both have an import. if not, a very short perl dbi script would do it nicely. -- Happy Trails! Jerry (K7AZJ) Hobbit Name: Pimpernel Loamsdown Registered Linux User: 275424 This email's random fortune: Be free and open and breezy! Enjoy! Things won't get any better so get used to it. --------------------------------------------------- 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