CODEWITHSUNDEEP
mysqlvb.netexcelimport
Roberto Becher
Roberto Becher

Reputation: 164

Import Excel Spreadsheet to MySQL DB using VB.Net

I've got this problem of importing excel data to MySQL database. I want to create a VB.net application that allows the user to browse the excel file then click upload and automatically all the data in the excel file will be saved into the database.

I've already created a VB.net form with the browse thing and my only problem is the saving of the data. Can someone help me please.. thanks..

Upvotes: 0

Views: 3801

Answers (1)

Devart
Devart

Reputation: 122032

  1. Store Excel file as comma separated text - CSV file.
  2. Import data using LOAD DATA INFILE.

Upvotes: 1

Related Questions