From: Peter Brawley Date: April 4 2005 10:07pm Subject: Re: Setting up a Chemical database List-Archive: http://lists.mysql.com/mysql/182126 Message-Id: <4251BA88.8060404@earthlink.net> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="=======AVGMAIL-4251BA886333=======" --=======AVGMAIL-4251BA886333======= Content-Type: multipart/alternative; boundary=------------010905030300040107010701 --------------010905030300040107010701 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Dave, />I have a customer who has sent my close to 300 chemical products >in word format? How do I translate this into mysql tables? / Save it from Word as comma- or tab-delimited, create a MySQL database & table, use ODBC Admin to create a DSN for that database, open the MySQL database in Access, in the Access database window click Tables on the Objects bar, select Get External Data from the File menu, click Import. PB --------------010905030300040107010701 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Dave,

>I have a customer who has sent my close to 300 chemical products
>in word format? How do I translate this into mysql tables?

Save it from Word as comma- or tab-delimited, create a MySQL database & table, use ODBC Admin to create a DSN for that database, open the MySQL database in Access, in the Access database window click Tables on the Objects bar, select Get External Data from the File menu, click Import.

PB
--------------010905030300040107010701-- --=======AVGMAIL-4251BA886333======= Content-Type: text/plain; x-avg=cert; charset=us-ascii Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Content-Description: "AVG certification" No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.1 - Release Date: 4/1/2005 --=======AVGMAIL-4251BA886333=======--