sallymzain    -- 10-12-2005 @ 3:47 AM
  I have a system that create a Contact Database using MYSQL. Lets say one company want to store their client contact number, they must keyin one by one in a textfield provided in a form. It is successful. So, now.. the problem is lets say the company already have a database. They just want to import the database and don't want to key in one by one in that field. Of course if they have thousands data they don't want to key in one by one right..? So, the only one that i think is they must convert their database to Word file then my system read from that file to store all the data in my database. So, i try to find how coldfusion can interact with word file but cannot find. Can you help me..

--child CF--

SOLID    -- 10-12-2005 @ 10:39 AM
  try exporting as an excel file and there should some documentation on how to convert a xls file intoMySql


jfill    -- 10-13-2005 @ 6:38 PM
  If you need to easily read the excel file check out cfx_excel2query.  I use it and it makes things very easy.  You can find it here


EasyCFM.COM ColdFusion Forums :