Extracting data from Microsoft Excel

[samsoft00]

How can i extracting data from Microsoft Excel columns into database ( and which Microsoft excel version - extension .xlsx, .xls), having challenges on how to get each column and what delimiter to use. I'll appreciate your prompt response.

[sedatsevgili-ideasoft]

I think you should use ';' delimiter to use Microsoft Excel.

[vishaldodiya]

To create database you can use wamp server , there you make your database and table which contain same columns as in your Microsoft excel columns then you just simply import your excel file which is in .xml extension .your excel file must be in .xml format.......

[segadora]

Use another library http://www.libxl.com/