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
Solved

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

Posted on 2013-01-21
2
1,611 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
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
Disk Wipe Utility 6 91
Free HD cloner 11 84
People Counting Software 2 212
SonarQube on Linux vs Windows 3 52
I use more than 1 computer in my office for various reasons. Multiple keyboards and mice take up more than just extra space, they make working a little more complicated. Using one mouse and keyboard for all of my computers makes life easier. This co…
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…
This video demonstrates how to use each tool, their shortcuts, where and when to use them, and how to use the keyboard to improve workflow.
Viewers will learn how to use the Hootsuite Dashboard.

861 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