I need to uplaod an excel table to my data base of my internet site.
I have two types of xls where the columns are in different order.
I attach tree file where:
- SERV [url removed, login to view] it corresponds for the columns of the DBase table.
- INST [url removed, login to view] is the other kind of excel that NOT corresponds with the columns of the Data Base table.
- and [url removed, login to view] is the Data Base Table (inst) from my site.
The data from each excel files to uplaod must to be change to text data and don't have ", @ É, Ú, etc or any other character that could have conflict with php that because I will read this with a flash movie component.
And on the date data must have two blank space before.
My DB works with MySQL.
6 freelancere byder i gennemsnit $161 for dette job
I made the same kind of work for the University of Feira de Santana in Brazil. I can provide examples if necessary. Jose Luis Alvarez Senior consultant UEFS