Excel ODBC drive. If I recall correctly, the worksheet names are treated
as table names and then the first non-blank row in the Excel spreadsheet
is treated as containing the field names (in Excel they would generall be
column headers).
I mostly used this to import data from Excel. Once in a CF query you can
manipulate the data easily enough, especially using CF's query of queries.
will correspond with a table
----- Original Message -----
From: "Mickael" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, July 05, 2004 8:53 AM
Subject: Manipulation Excel files
> Hello All,
>
> I was wondering if someone could point me in the right direction. I
need to be able to extract certain information from cells an excel file,
update some cell, delete some rows in the file then import the file to my
database. Can anybody point me to a resource that explains how to do this
or if someone has some experience with this it would be greatly
appreciated.
>
> Thank you,
>
> Mike
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
