I've got a way thats been working great for me....
Setup your microsoft access dsn. Go into microsoft access and create a
linked table to the excel file. In your cold fusion scripts do a insert
into accesstable(var1, var2, var3) select var1, var2, var3 from excel
table....
That should work fine. Its even nicer because you can keep ftping a new
file that overwrites the existing one (as in my case), and rerun the query
if needed.
Steve
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 15, 2000 6:46 AM
To: CF-Server
Subject: Exporting from Excel to Access Clarification
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
