The client has made the following changes to the job.
Bidding period extended.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
PHP / MySQL
I need to import a medium sized Excel spreadsheet (example attached, there are only approx 1300 rows and 30 columns) into MySQL and have my staff be able to continue to use the new DB as they used the Excel before.
Due to the number of columns in the spread sheet it will need to be simplified slightly just to make it more user friendly.
There is a proof of concept that has been created by a staff member but i just need it written professionally.
The data has been recorded in the XLS on multiple lines per unique client.
We have an internal client reference number but we cant use it as a primary key initially as the XLS is not fully up to date (not every row has the unique client reference number added as yet). so we will need to import each row as a separate client with a unique primary key for each row and once we have added all of the internal client reference numbers we can than group each row with the same client reference number as the same client.
the last li...
Sign in or Register to see more