1 Reply Latest reply on Jul 21, 2006 3:07 AM by CFcippa

    excel upload

    JohnGree Level 1
      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?

        • 1. Re: excel upload
          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.