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.
Jump to PostHi, can you show us the insert script?
Hi, can you show us the insert script?
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
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.