PHP to communicate w/ other programs? [Archive]

Click to See Complete Forum and Search --> : PHP to communicate w/ other programs?

sveegaard

Jun 13th, 2006, 07:45 AM

Hi all,

I've given up a project with VB to communicate with SolidWorks and dump data to Excel (MS made an update that crashed my little program :cry: ). So I decided to try the same with PHP - but my question is now: How do I import data from a SolidWorks file to MySQL? The file type is .slddrw and when the files are opened in Wordpad, my wanted data is 100% readable. However, it is surrounded by squares (♦) so I don't know where I need to 'cut' the rest of the text.

Hope you will/can help me - I can mail a sample file if nescessary.

sveegaard

Jun 13th, 2006, 09:17 AM

Maybe it's smartest by making SolidWorks communicate wit hmy databse in MySQL. How do I make VBA import data from MySQL?

beasty1711

Jun 29th, 2006, 04:21 PM

Maybe it's smartest by making SolidWorks communicate wit hmy databse in MySQL. How do I make VBA import data from MySQL?

If you install the MySQL ODBC Drivers (http://dev.mysql.com/downloads/connector/odbc/3.51.html) then you can access MYSQL like you would any other OLEDB