• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Importing Excel into Oracle

New Here ,
Jan 03, 2007 Jan 03, 2007

Copy link to clipboard

Copied

Scenario:
7 users have access to an Excel Sheet.
Any user can use the coldfusion front-end and upload this excel file into an Oracle database.
Excel sheet has 30 columns, but when they click on Upload...only 5 0r 6 columns will be filled.
The rest will be null values in the database.
I'm not in a position to make use of Oracle External Tables neither can I run DB scripts to check for newer Excel Uploads.
As of now I need suggestions on the possible approaches.

Also when user clicks upload:
If col-1 has value then col-2, col-3 should have values and col-4, col-5 should not have any values.
There will be checks like these in place too.
Please suggest how do I check an .xls file if all these conditions are filled per row (assuming that there would be 40 rows per upload per user per day). Do I check the .xls file or do I check for these validations somewhere else, if yese where and how ??
TOPICS
Advanced techniques

Views

246

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Jan 03, 2007 Jan 03, 2007

Copy link to clipboard

Copied

Please suggest how do I check an .xls file if all these conditions are
filled per row (assuming that there would be 40 rows per upload per user
per day). Do I check the .xls file or do I check for these validations
somewhere else, if yes where and how ??

Either on these forums of the House of Fusion forums, I recently read a
thread about using excel as a datasource. That may offer you some options.

The file could be uploaded to a given location. That location is
configured as a datasource. Use standard SQL operations against it.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Jan 03, 2007 Jan 03, 2007

Copy link to clipboard

Copied

Will try what has been suggested. Is there anything more conventional though?

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Jan 04, 2007 Jan 04, 2007

Copy link to clipboard

Copied

LATEST
Why couldn't you upload the Excel and then use cfhttp to take it and turn it
into a query which you can loop into a database? I do that with CSV files
all the time. Wouldn't that work for Excel?


Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation