Hi,

In an excel file, I have 10 headings and that file contains more than 6000 records.
I upload file using oleread.inc and excelreader file.
It takes time to upload recods in table minimum 4 - 6 minutes.

How to decrease the time and insert records in table fastly.

Re: Excel Upload fast 80 80

Hi, can you show us the insert script?

Re: Excel Upload fast 80 80

If you can change preference of file type, from excel to csv then after uploading csv file to server, you can use "load data infile" available in mysql

http://dev.mysql.com/doc/refman/5.7/en/load-data.html

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.19 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.