Create an Access Database to re- format data from a csv file. - Microsoft Access MySQL PHP
Start point - a fulfillment list (fulfillment.csv) containing a list of orders - emailed from Infusionsoft. End point - an Excel 2000 spreadsheet, re-formatted for Import into Our Fulfillment Software - Cyrane. Please see attachments: 1. fulfillment.csv - an example of the Order List from Infusionsoft (start point). 2. orderimportGB.xls - an example of the Order List for import into Cyrane (end point) 3. Field Mapping - a spreadsheet showing field mapping and field requirements. 4. Detailed Notes - a word document with detailed requirements. The Finished Access 2007 database should be Linked to the .csv file (which will stay in one folder on our internal office server) and have a single Macro Button to press to run the conversion and output the Excel Spreadsheet to another fixed location from where it can be manually imported. Desired Skills: Microsoft Access MySQL PHP Keywords: Database Development, MySQL, PHP, Access, Microsoft
| Expired |
Ana Hartman
Writer
View profile
Tim McKean
Multimedia Expert
View profile
More microsoft access mysql php projects
View AllRelated projects
Search for freelance jobscan’t wait for more clients
and advertising. Thank you."