Advertisement

09.05.2008 at 12:21PM PDT, ID: 23707452 | Points: 250
[x]
Attachment Details

Importing data from an Excel file

Asked by VentureLabour in Cold Fusion Markup Language, Microsoft Excel Spreadsheet Software, ColdFusion Studio

Tags: ,

I need to import an excel file into an SQL database. There are certain complications in reading though. I am getting the files in a pre-defined format. I have attached the format. I have headers marked in yellow background. So there are 2 types of Information that I receive in the excel spreadsheet. The first set of data will be just a single row and will be dumped in to my header table. The second set of data will be multiple rows and will be dumped in to a details table. So I need to read the first set of data first and dump it in to database and then read the second set of data and dump it in to details table. Also there will be multiple worksheets in the file which I need to read and get the data.

Thanks,
ParagStart Free Trial
Attachments:
 
data-sample.xls (20 KB) (File Type Details) 
Sample Data File
 
[+][-]09.05.2008 at 12:25PM PDT, ID: 22402780

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]09.05.2008 at 12:27PM PDT, ID: 22402797

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]09.08.2008 at 09:45AM PDT, ID: 22419164

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20081112-EE-VQP-42 / EE_QW_2_20070628