You also have to make sure that you define an Excel LIST (this will refer to
the table name) and the column headings contained within this table have to
conform to the usual table name specs (i.e. no dodgy punctuation or spaces,
etc.)
Si.
Sapphire Technologies Ltd.
Secure in the Knowledge
Simon Halcrow Web Developer
E [EMAIL PROTECTED]
T +44 (0)1642 702100
F +44 (0)1642 702119
W www.sapphire.net
> -----Original Message-----
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, January 26, 2001 9:04 AM
> To: CF-Talk
> Subject: RE: transfer excel data to sql server db thru
> programmatically (u rgent!)
>
> Have tried searching the Allaire Tag Gallery on www.allaire.com.
> Their search facility is excellent.
>
> For writing information to an Excel spreadsheet, you can access it the
> same
> way as a database using an Excel driver for ODBC.
>
> Mike
>
> -----Original Message-----
> From: ramesh deva [mailto:[EMAIL PROTECTED]]
> Sent: 26 January 2001 04:01
> To: CF-Talk
> Subject: transfer excel data to sql server db thru programmatically
> (urgent!)
>
>
> Hi all,
>
> I have one cfm page which allows to me to select one
> excel file and after that when i submit the page then
> wat ever i selected data from xls file data has to be
> insert into specified table..
>
> And we are using window NT and CF4.5.1. and MS sql
> server 7.0.
>
>
> Is there any custom tag avaialble in allaire.. or any
> indirect way we have to approach???
>
> I would appreciate if u give yr valuable suggestions.
>
> Actually this one already posted in to cf-talk..
>
> but my problem was not solved..
> Pls let me know any one faced this problem earlier..
>
>
> Thanks in advance
> Ramesh
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
