go to access, select get external data from file and select import
open up the excel file that you want to import and follow the Import
Stylesheet Wizard for the rest of the proceedure.
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "CF-Server" <[EMAIL PROTECTED]>
Sent: Friday, December 15, 2000 10:11 AM
Subject: Exporting from Excel to Access
> Hi,
>
> Can someone please assist me on how to read an Excel file and take the
> contents to a Access database.
> I have created an Access DB with the same field names and have a DSN set
up
> for the Access database.
>
> How do I read the Excel file and insert row by row to the Access DB?
Thanks
> in advance.
>
> Pallav
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
