Import Data from XLS into Database

Question

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 ID	Away Team ID	Field ID	Date	Time	League ID
548	154	35	26-Jul-10	6:00 PM	128
154	548	35	26-Jul-10	7:30 PM	128
561	536	35	27-Jul-10	6:00 PM	128
536	561	35	27-Jul-10	7:30 PM	128
548	532	35	28-Jul-10	6:00 PM	128
532	548	35	28-Jul-10	7:30 PM	128

Thoughts...

JR__Bob__Dobbs-qSBHQ2 · Answer

Some options:1. Use CFSPREADSHEET. Allow users to upload an xls file which is then read by CFSPREADSHEET. The data from the resulting query object can then be inserted into your database. http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec17cba-7f87.html2. Use your database's import tools, if any. If your database supports importing data from xls you could let your users upload an xls file. Then use the database's import features to import the data from the spreadsheet. What database are you using?Either of the options above would use CFFILE to allow the user to upload files to the server.http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-738f.html

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded