Hi,
> Does anybody knows if there is an easy and fast way to convert MS Outlook
> 2000 contacts database into a MySQL table?
It should be very easy for you to export your Contacts folder to MySQL.
Simply choose the 'Import and Export...' menu command and tell Outlook to
export to a tab-seperated file. You can then import this file to MySQL using
the LOAD DATA INFILE syntax.
One thing to watch out for though is that any Outlook fields with line
breaks in them will be exported with the contents of just these fields
quoted with speech-marks. You will need to add a OPTIONALLY ENCLOSED BY '"'
parameter to the LOAD DATA command. For example:
LOAD DATA LOCAL INFILE 'outlook_contacts.txt' INTO TABLE tbl_name FIELDS
TERMINATED BY '\t' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\r\n';
Also, if you are looking to automate the process, then I'm sure you can
write some VBScript to control the export from Outlook.
> It's very important for for to have transferred into MySQL a 256
> chars key
> that is being used from Outlook as the primary key for the contacts.
I'm not sure what key field in Outlook you're referring to, but as far I can
tell, all the fields that are present in the Contacts store are exported to
the text file.
Regards,
Basil Hussain
---------------------------------------
Internet Developer, Kodak Weddings
E-Mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
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
