Need an SQL query written to bulk import CSV data, allowing for column selection
$30-250 USD
Pagado a la entrega
Hi -
I need a script written which should be fairly easy and straightforward to import CSV data. Couple of points:
1) it needs to be able to efficiently and expediently import sizable amounts of data (up to 100,000 records).
2) I don't want it to be a stored procedure, it needs to be query based so I can call it from multiple servers via web scripts.
3) I need to be able to dynamically specify the columns. As an example, I need to be able to say "column 4 in the CSV file needs to insert, into Column Name X in the table, column 5 in the CSV file needs to insert into Column Name Y in the table etc.
4) I'd like the above (step 3) to be plainly laid out at the top of the code (via variables if need be) and not buried deep in the query so that developers unfamiliar with the script have to go digging for it.
That's it. Should be straightforward. I'll provide a SQL structure and CSV file for testing for the winning bid. Thanks.
Nº del proyecto: #6324086
Sobre el proyecto
Adjudicado a:
Hello John, Let me do this task for you, i will use the sql statement not store procedure. Also, do you want the GUI for choose the mapping columns? Best regards. Thanh
19 freelancers están ofertando un promedio de $178 por este trabajo
I can do this as a desktop application or web application (php,jsp,..) 1. I will use hash map to input variables (column names ) to the query. 2. Then it will build a sql query using specific column names 3. Then i Más
Hi, I have done this for SQL Server as well as MySQL. There are specific commands for Bulk import from csv files. I will do it and provide the same day you award the project. Looking forward to hear from you s Más
php mysql expert here with 3 years of experience in web development. I am available now and ready to do this for you. lets do it
Hi I'm MS SQL Server Expert. I think best way for your poject create a Application for generate SQL Query pm me for more info and see demo
10 Years experienced in application development. Worked for major clients in UK full time. Started freelancing recently.
I have worked extensively on reading, importing and exporting CSV's to Oracle Database and reading table data to export it to flat files since i have been working on it since last 5years.