Thanks Steve,
I also saw the following article.
http://www.cfcomet.com/cfcomet/excel/index.cfm?ArticleID=0239B2E5-5FED-11D3-B3E9004033E03EF9
Thanks for your help.
Pallav
--- Steve <[EMAIL PROTECTED]> wrote:
> 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
