Automated Data Import from EXCEL

[thesti]

hello,

how to programmaticall y 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]

Solution to Automated Data Import from EXCEL

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