> We are moving away from windows all together in the office I work for, one
of
> our major programs that we use here is ACT2 DB. Can someone point me in
the
> right direction of converting a ACT2 DB to MySQL.
If it's any help, I recently used the following method to successfully
convert an ACT2 database into MySQL:
(i) open the ACT data file [your_database].dbf using MS Excel
(ii) manually "clean up" the data in the spreadsheet, eliminating
unnecessary columns, values, etc.
(iii) save the spreadsheet as a tab delimited text file
(iv) create tables in MySQL with appropriate column types for the data to be
stored in them
(v) load the text file into the tables using the mysqlimport utility
Best of luck!
Chris
--
Waverley Internet Design
http://www.waverley-internet.co.uk
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
