Import Data into SQL server from Excel file into a single table
- or -
Post a project like this- Posted:
- Proposals: 20
- Remote
- #1987926
- OPPORTUNITY
- PRE-FUNDED
- Awarded
Description
Knowledge of the application is not require as this is all done at the database level however anyone with experience with Maytas 5 system from Tribal may have an advantage or worked with ILR data, but again this is not required.
You will require good communication skills and have access the the server remotely via GotoMeeting or teamviewer. You will also be required to sign a confidential document and none disclosure document as the data contain personal information i,e names and address information.
I've attached a sample of the Excel file and can also provide the XML file if required
Lee W.
98% (26)New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hello Lee,
Is this task still actual / active at the moment?
Thanks.
Best regards,
Ivan -
Lee i guess store procedure already there, or it also has to be done. Also which database you using (MS Sql, MySql, oracle or anyother)
Lee W.26 Apr 2018Stored procedure is already there and there is a trigger set on insert on the import table to run that which should import the data once its been added to the temporary table.
AVR S.26 Apr 2018are you looking one time import or you looking a application where you can select the Excel or CSV file and insert data to database.
-
Hi Lee,
It will be difficult to estimate fix price, without understanding the changes ( Modification required ) in SQL stored procedures.
Is it possible for you to show us the stored procedure via team viewer ?
I look forward to your reply.
Regards,
DharmeshLee W.26 Apr 2018the stored procedure is already 95% complete. this is just to add the text into the temp table