Need help updating MySQL from MS Access

[unique1tt3]

Ok. I know you can do this but god knows if I know how. So see if anyone has any ideas.

Every day I get a database sent to me in access. The format sucks and the database is quite usless minus that fact that it has some information I need to expand on. I built a site in php with mysql. What I want to do is try and import the new records from the access database to mysql database in some sort of automated way. I need ideas. To give you an idea of the setup here we go.

The access database is stored on the same server as the mysql.
DRIVE R.

I want to take the products table of the acces and get info from a couple of the rows and import that to my inventory MySQL table daily.

The rows in access are,
item_num,
price,
stock,

And Place that into my table in MySQL,
product_number,
our_price,
quantity,

I need it to look at the database and only get the item_num's that are currently not in the mysql database under product_number. You know compare and get what is not listing. Is there anything I can do to complete this task. ANY IDEAS WOULD BE GREAT! I have been trying a million things but the access database is still going to be comming over every day and I really would like to use the sql to allow people to hit it from an webpage. And I cant change the format of the access because it is uploaded to the server every night and needs to be updated every morning.

[leatherback]

Hi,

I know you can create reports in ACCES> Why not try this:

Create a report template, which holds all the basic PhP / SQL commands that you need for each record:

Select * from MyTable where MyId = ACCES_ID
If( Mysql_Num_Rows($selected) == 0)
{
Insert into MYSQLDATABASE -- Record from ACCES
}

Then every day you can just create that report when the acces comes in, add PhP tags, and open the file on your server. It will then check automatically all the records in the new ACCES file against the MySQL database.

J.

[unique1tt3]

thanks not a bad idea but I was hopping of an automated way. Didnt know if there was some software or maybe a script I could use that would do it for me. Its just that on days I am not there nothing gets done and they cant stop getting that dumb access file

[unique1tt3]

does anyone else have a sugestion?

[unique1tt3]

is there a way to say have php do it when you open up a page say. Like have a link to UPDATE NOW. Open the page and have it perform the update. I would really rather have php and mysql do it rather then have to do anything in access.