Import - Read file

[ttnguyen]

Hello,

I have been working with ColdFusion and DB2 for about 1 month. I have a
question and hope someone could me me with.
"How can I import an excel file to DB2 table"?

Your help would be appreciated.

-Thien

 

[Bob Walton]

ttnguyen wrote:

....

I have been working with ColdFusion and DB2 for about 1 month. I have a
question and hope someone could me me with.
"How can I import an excel file to DB2 table"? ....


-Thien

....


And your Perl question is? Oh, you want to do it with Perl, not
ColdFusion? Modules are your friend. Check out:

Win32::OLE (if you're on Windoze)
DBI
DBD:B2
DBD::Excel
DBD::ODBC (if you're on Windoze)
Spreadsheet:arseExcel

 

[ttnguyen]

Originally posted by Bob Walton

ttnguyen wrote:

...
...


And your Perl question is? Oh, you want to do it with Perl, not
ColdFusion? Modules are your friend. Check out:

Win32::OLE (if you're on Windoze)
DBI
DBD:B2
DBD::Excel
DBD::ODBC (if you're on Windoze)
Spreadsheet:arseExcel

Thanks for your answer. I do it with coldFusion NOT Perl. Thanks.