Prev: PDF full screen
Next: Help! Navigation bar disappeared after re-publishing!
From: med211 on 7 Jan 2010 16:49
I would like to build a form which will have only the persons name, address,
city, state, zipcode and country.

But I would like to know how to make it show up in a Excel spreadsheet with
the results.

Tks,
Jeff


From: Andrew Murray on 7 Jan 2010 17:08
I don't think you can do this with the FP extensions (not write directly to
an excel file).

Create your form, go to the form properties, then choose the "Send to"
option and specify the file name in the "File Name" field. While that
option is selected, click "Options" for more options related to the file
format - e.g. you can save as basic formatted text file / HTML - but nothing
as specific as an Excel file.

Possibly the best option would be "Text Database with comma as separator" -
which can be relatively easily imported into Excel.



"med211" <jkerry(a)charter.net> wrote in message
news:#lN3YN#jKHA.2164(a)TK2MSFTNGP02.phx.gbl...
> I would like to build a form which will have only the persons name,
> address, city, state, zipcode and country.
>
> But I would like to know how to make it show up in a Excel spreadsheet
> with the results.
>
> Tks,
> Jeff
>
From: Billy Ray on 7 Jan 2010 17:52
YES but you need to go to
microsoft.public.excel Newsgroups or microsoft.public.sqlserver.oddc
Newsgroups can help you out

"med211" <jkerry(a)charter.net> wrote in message
news:%23lN3YN%23jKHA.2164(a)TK2MSFTNGP02.phx.gbl...
> I would like to build a form which will have only the persons name,
address,
> city, state, zipcode and country.
>
> But I would like to know how to make it show up in a Excel spreadsheet
with
> the results.
>
> Tks,
> Jeff
>
>


 | 
Pages: 1
Prev: PDF full screen
Next: Help! Navigation bar disappeared after re-publishing!