Hi,
I want a MySQL stored procedure which can parse an excel file and save it in the csv format,after which the values in the file can be imported into a table.


Kindly help me with a solution for this asap.

Thanks,
Narayana

I don't think a stored procedure can read from the filesystem. You may have to find a different solution.

Be a part of the DaniWeb community

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