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
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.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.