Solved

How to use LOAD DATA INFILE for Store Procedure Via VB.net

Posted on 2013-01-21
2
1,625 Views
Last Modified: 2013-01-22
HI All,
Im trying to use

LOAD DATA INFILE 'FileName'
IGNORE INTO TABLE TableName
FIELDS TERMINATED BY '","'
LINES TERMINATED BY '\r\n' ;

But it show Load Data Infile not able to use in Store Procedure. Is there any others solution able to let me pump my huge(data size around 2gb) into my MYSQL db?
0
Comment
Question by:AFA-TECH
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 39

Accepted Solution

by:
Pratima Pharande earned 500 total points
ID: 38804084
0
 

Author Closing Comment

by:AFA-TECH
ID: 38808377
Thanks pratima_mcs for the solution.
It able to run now....
Thanks
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Scripting vs. Programming languages 25 207
Software for IT quotations, invoices, delivery orders 2 62
WinX Downloader fails to analyze. 10 71
API v SOA 8 40
In this article, you will read about the trends across the human resources departments for the upcoming year. Some of them include improving employee experience, adopting new technologies, using HR software to its full extent, and integrating artifi…
Developer portfolios can be a bit of an enigma—how do you present yourself to employers without burying them in lines of code?  A modern portfolio is more than just work samples, it’s also a statement of how you work.
Video by: Tony
This video teaches viewers how to export a project from Adobe Premiere Pro and the various file types involved.
Viewers will learn how to use the Hootsuite Dashboard.

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question