Automated Data Import from EXCEL

[thesti]

hello,

how to programmatically from VB .net / php. to import data from an EXCEL file?

is there's no programmatic way, how to automated the process. as i search, the process is:

Simply export data from excel as TXT or CSV. Than use MySQL command
LOAD DATA INFILE 'path/file.txt' INTO TABLE your_table;

so,
1. export data from excel as CSV
2. use the command LOAD DATA INFILE

i can create a batch file to run the LOAD DATA INFILE command, but how can i automated the process to export data from excel into CSV, so users only have to click a single file to export the data.


Thank you.

[nbiswas]

This may help (atleast generating the idea)

import excel file to database in php

And on VB.Net

a) Import data

b) Excel Connectivity in VB.NET

[thesti]

thanks nbiswas,

i'll check those out