import from excel

[emmim44]

Goal: How to import data from an excel file to an oracle or access db.

Help needed.
tc

[jonwrob]

Access has a built in tool for importing from Excel. TOAD has one for Oracle if you have it, if not, save as comma delimited or tab delimited file and use SQL Loader.

JR

[emmim44]

Noap...I want to browse to an excel file then read it and insert into oracle db..tc

[vkunirs]

Hi

You can use the cffile to read the content of the excel data and then insert the data into the db using the cfquery.

just an idea.

[emmim44]

How ..

[mxstu]

Originally posted by: vkunirs
You can use the cffile to read the content of the excel data and then insert
the data into the db using the cfquery.


I'm not sure what you mean. You can read in and parse a .csv or tab delimited
file with cffile, but native .xls files are binary.

[kim il sung]

try cfx_excel2query from
[url]http://www.emerle.net/programming/display.cfm/t/cfx_excel2query[/url]

Transform a Microsoft Excel file into a ColdFusion query without installing
Excel on your server! This tag is written in 100% java, so there is no need for
the dreaded COM. This tag works best with simple Excel files, but many have had
luck with extremely complex files.

cheers,
Kim