So where are the questions?
Miriam Hirschman wrote:
>
> 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?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?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.