Parse Data from MS-Excel file

Thread Solved

Join Date: Jun 2008
Posts: 28
Reputation: cheapterp is an unknown quantity at this point 
Solved Threads: 2
cheapterp's Avatar
cheapterp cheapterp is offline Offline
Light Poster

Parse Data from MS-Excel file

 
0
  #1
Mar 12th, 2009
Here's the problem:

One of my scripts allows users to upload MS-Excel files. When uploading the file, users are also required to enter details related to the file - details like start date, stop date, a description of what the file contains, and the file ID#.

This Excel file contains 1000s of data points each of which has a date and time record. Based on the dates entered in the form, I would like to grab only those records from the file that fall within these dates and dump all the selected data in a table in the DB.

Anyone know how I could do the "Selection of Records" part of the problem?

Thanks!
Reply With Quote Quick reply to this message  
Reply

This thread has been marked solved.
Perhaps start a new thread instead?
Message:




Views: 1421 | Replies: 0
Thread Tools Search this Thread



Tag cloud for ColdFusion
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC