Last post Aug 18, 2017 08:49 PM by homertechnologies
Aug 18, 2017 10:37 AM|kengkit|LINK
hi guys.. i gonna import 25k++ records from excel file to mysql database.
Is there any simplest & fastest way to import directly from excel to mysql database instead of showing records in Gridview and import one by one?
Aug 18, 2017 11:01 AM|mgebhard|LINK
See MySQL support. Generally you just convert the excel file to a delimited file then import the file.
If you have phpMyAdmin installed, you can do it through there...
Aug 18, 2017 08:49 PM|homertechnologies|LINK
The trick here is to prepare the excel file correctly, how your mysql interface wants.
You can create one page application in asp.net to import. or use mysql workbench