Solved

How to write to an Excel file on the server

Posted on 2003-11-18
4
1,305 Views
Last Modified: 2013-12-24
I can use CFCONTENT to write data to an Excel server. I can create an datasource and query an Excel table. But how can I insert data into an Excel file on the server?
0
Comment
Question by:kjuliff
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 19

Accepted Solution

by:
cheekycj earned 250 total points
ID: 9773723
0
 
LVL 17

Expert Comment

by:anandkp
ID: 9776326
well if u can read thru excel sheet - then i guesss the same DSN shld help u to write to the excel file as well.

If ur using CFMX 6.1 - then in ur CFADMIN - under ur datasources - u'll see a option "advanced settings" - in that u have checkboxes for insert / update etc for the excel DSN. chk the ones u need & u shld be able to insert/update ur excel sheet on the server.

also u'll have another checkbox there "maintain connection" - make sure this is UNCHECKED !

ur insert query to the excel sheet will be as similar as the one to any DB Table ...

HTH

K'Rgds
Anand
0
 
LVL 17

Expert Comment

by:anandkp
ID: 9776327
well if u can read thru excel sheet - then i guesss the same DSN shld help u to write to the excel file as well.

If ur using CFMX 6.1 - then in ur CFADMIN - under ur datasources - u'll see a option "advanced settings" - in that u have checkboxes for insert / update etc for the excel DSN. chk the ones u need & u shld be able to insert/update ur excel sheet on the server.

also u'll have another checkbox there "maintain connection" - make sure this is UNCHECKED !

ur insert query to the excel sheet will be as similar as the one to any DB Table ...

HTH

K'Rgds
Anand
0
 
LVL 19

Expert Comment

by:cheekycj
ID: 9782393
A "C", if you didn't like my comment you shouldn't accept it as an answer.

It was just for reference.

CJ
0

Featured Post

Save the day with this special offer from ATEN!

Save 30% on the CV211 using promo code EXPERTS30 now through April 30th. The ATEN CV211 connects a laptop directly to any server allowing you instant access to perform data maintenance and local operations, for quick troubleshooting, updating, service and repair.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Apached AXIS end to end simple good example 2 120
Unsearchable in Google,Yahoo and Bing. 6 72
Redundant SQL Servers Without Clustering 7 157
Problem to copy file 14 92
If you don't have the right permissions set for your WordPress location in IIS, you won't be able to perform automatic updates. Here's how to fix the problem.
What You Need to Know when Searching for a Webhost Provider
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…
Suggested Courses

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question