3 Replies Latest reply on Jun 14, 2010 6:31 AM by Merle_Hanson

    Import Data from XLS into Database

    Merle_Hanson Level 1

      I am trying to create a schedule importer in Cold Fusion - where a league can do their schedule in XLS first, then import it into the database.

       

      www.slopitchleagues.com - there is an automatic system they can use - but have to enter them manually...

      So I've had a request to do it with an XLS file...

       

      An example of the XLS fields required are below...

      Basically starting on the 6th row (instructions on prior rows)

      And importing till last row...

       

       

      Home Team IDAway Team IDField IDDateTimeLeague ID
      5481543526-Jul-106:00 PM128
      1545483526-Jul-107:30 PM128
      5615363527-Jul-106:00 PM128
      5365613527-Jul-107:30 PM128
      5485323528-Jul-106:00 PM128
      5325483528-Jul-107:30 PM128


      Thoughts...