Skip to main content
July 21, 2006
Question

excel upload

  • July 21, 2006
  • 1 reply
  • 501 views
Hi i have a mysql database which i want user to upload there excel spread sheet to

i have tried using cfgrid but i would like the user to be able to copy whole columns of data from excel to cfgrid is this possable?

or is there another way of uploading a excel spreedsheet to my sql database?

thanks
This topic has been closed for replies.

1 reply

Participant
July 21, 2006
Hi I have mapped the excel in the datasource of coldfusion (don't check the maintain database connection).
The users have a tool. They upload their excel (well formatted as plane table) in the position of my mapped excel (datasource) and then after some data format controls there is a component that insert the data in a MS SQL server.
They can upload multiple sheet excel file.
It work good, it could be a good way.