import a table into my sql DB with some modifications
$10-15 USD
Tamamlandı
İlan edilme: 13 yıldan fazla önce
$10-15 USD
Teslimde ödenir
? I have an excel spread sheet which have the same headings a table in my DB.
I need to import in to overwrite the content of the existing table. It needs to be imported as an SQL file.
I will provide you with an Excel file to convert to an SQL file to be added to a DB table in it called "mc_business". That is the only table that needs to be? modified.?
? ?
?
There are 3 extra columns in excel file, that are not in this table, please add them:
- address2
- province
- listing_type
Many columns in the Excel file are empty (blank) that is fine
The phone number field is a text field, is does not have to be perfect.
I just need the file converted to an SQL file? - then imported in the table called "".
## Deliverables
Once the table is installed the successful applicant can work with me to finish work on the site.
Our preference is that the work is done fairly quickly.