Sorry, I did not memtion this earlier. I need to do the exporting thru
Cold Fusion. The end users do have access to the database. Basically, the
end user has some data on an excel spread sheet that needs to be posted to
the database.
Pallav
----- Original Message -----
From: "Kaigler" <[EMAIL PROTECTED]>
To: "CF-Server" <[EMAIL PROTECTED]>
Sent: Thursday, December 14, 2000 10:18 PM
Subject: Re: Exporting from Excel to Access
> Click on File within Access
> Click on get external data and within that click in Import.
> Find the appropriate file (make sure you select the correct file type)
>
> walk through the spreadsheet wizard.
>
> very easy.
>
> Let me know if you have any other questions regarding this.
>
> kaigler
>
> At 09:11 PM 12/14/00 -0500, you wrote:
> >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
