Hi,
Thanks for helping me out. I hop you don't mind that I am emailing you
directly. I have 3 questions. Firstly, the file in excel leaves a blank
line between each record. Also before the first field there is a square
character. My last question is that one of the fields that I am exporting
to access is like a memo field and whenever I export it (using the code you
gave me or someone elses) it splits the memo field into a few records. I
see that this does happen by a period, although not all the time.
Thanks a lot for your help,
Miriam Hirschman
-----Original Message-----
From: Eron Cohen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 13, 2000 4:41 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: Export to Access
Miriam,
Excel/Lotus 123 is easy. Here's a very simple solution that works great for
creating CSV files and opening them up into Excel or Lotus (or whatever is
handling comma seperated files on the client machine). The gist of this is
that CFCONTENT will cause the browser to put up an "Open File or Save"
dialog box. If they push OPEN, Excel will open up and display the info that
CF outputs:
<CFSETTING enablecfoutputonly="Yes">
<CFQUERY name="search_results">
Select *
from something
</CFQUERY>
<CFCONTENT TYPE="text/x-excel-csv">
<CFHEADER NAME="content-disposition" VALUE="filename=contacts.csv">
Report For Someone:
<CFLOOP QUERY="search_results">
<cfoutput>"#first_name#","#last_name#","#COMPANY_name#","#state#","#country#
","#company_address1#","#company_city#","#state#","#company_postal_code#","#
contact_phone_number#","#contact_email_address#"
</cfoutput>
</CFLOOP>
There are also custom tags that you can get in Allaire's tag gallery that
are more specifically tied to Excel, but excel would need to be installed on
the server.
HTH,
Eron
-----Original Message-----
From: Miriam Hirschman [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 13, 2000 1:10 PM
To: CF Forum
Subject: Export to Access
A client of mine wants to know if there is a way that I can export a CF page
to access or excel?? I would appreciate any info
Thanks,
---miriam
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=sts&body=sts/cf_talk or send
a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
