Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access Data to PHP

Status
Not open for further replies.

matrixindicator

IS-IT--Management
Sep 6, 2007
418
BE
Hello,

I have a report in access that I want to transfer to a .php website. Its a Stock List of cars.
1. First upload with ftp the report transfered to a word .doc from in ms access = OK.
2. Secondly I like to transfer the data of the report to the .php website (without the Admin page), just with ftp. Question is, should I send a file .txt or can I inject my data in the MySql database directly or is there a other way.
The datasource should feed a designed webpage.

I know .php can use as datasource tables MySql and text files. Or are there other way to easily upload the data ?
What do I need to do (without using the PhpAdmin).

tx
 
Export from Access direct to XML file
FTP XML file
Use XML file direct from PHP

A quick search on this forum will yield several solutions to the last bit, including faq434-5576

If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
 
tx to answer,

I think my version ms access does not provide export xml. (version 2000). Access 2007 provide xml export I think.
 
or perhaps, I should write myself the xml tags in access ? I have written before html tags to a txt file.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top