|
 |
access thread: access2000 Output to CSV file type .
Message #1 by ddyble@s... on Tue, 29 Jan 2002 11:38:05
|
|
Does anybody know how to OutputTo a CSV file.
All the available formats are not what I require .
I am trying to create , from a form , a simple list of staff members to a
file called "Employee.xxx" where xxx is the number of the depot.
I have managed the last bit using a command button and actually sending
the file i.e. I went to record 10 (our depot 010) and created a file on
the default area called "Employee.010" but the file is only in the
following formats (*.asp),(*.xls),(*.htx, *.idc), MS-DOS Text (*.txt),
Rich Text Format (*.rtf), or Microsoft Data Access Page (*.html) none of
which are suitable ...... I just need a CSV output, No headers .
Message #2 by brian.skelton@b... on Tue, 29 Jan 2002 13:31:13
|
|
Try using the TransferText method instead. This gives you much more
control over the output format.
Brian
> Does anybody know how to OutputTo a CSV file.
> All the available formats are not what I require .
> I am trying to create , from a form , a simple list of staff members to
a
> file called "Employee.xxx" where xxx is the number of the depot.
> I have managed the last bit using a command button and actually sending
> the file i.e. I went to record 10 (our depot 010) and created a file on
> the default area called "Employee.010" but the file is only in the
> following formats (*.asp),(*.xls),(*.htx, *.idc), MS-DOS Text (*.txt),
> Rich Text Format (*.rtf), or Microsoft Data Access Page (*.html) none of
> which are suitable ...... I just need a CSV output, No headers .
Message #3 by "Randy Cornish" <rlcornish@c...> on Wed, 30 Jan 2002 00:29:34
|
|
You might try going into Office Setup (Control Panel) and check to see
what filters you installed. (Office Setup, Shared Features, Convertors &
Filters). You may have to add CSV to the list. The CSV option appears
on my machine.
R
> Does anybody know how to OutputTo a CSV file.
> All the available formats are not what I require .
> I am trying to create , from a form , a simple list of staff members to
a
> file called "Employee.xxx" where xxx is the number of the depot.
> I have managed the last bit using a command button and actually sending
> the file i.e. I went to record 10 (our depot 010) and created a file on
> the default area called "Employee.010" but the file is only in the
> following formats (*.asp),(*.xls),(*.htx, *.idc), MS-DOS Text (*.txt),
> Rich Text Format (*.rtf), or Microsoft Data Access Page (*.html) none
of
> which are suitable ...... I just need a CSV output, No headers .
Message #4 by "Leo Scott" <leoscott@c...> on Tue, 29 Jan 2002 16:37:41 -0800
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0012_01C1A8E3.44F60160
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
When you use the xxx, highlighted below, in the message or subject, many people's Outlook Adult Content rules will flag
the message as an Adult content message. Some of these automatically send it to the "Deleted items" folder.
I couldn't figure out why some of the messages on this DL were being colored for Adult content, then I looked it up in
the Outlook 2000 help and found that filters.txt contains the rules for determining Junk and Adult messages.
It was in my C:\program Files\Microsoft Office\Office folder.
>-----Original Message-----
>From: Randy Cornish [mailto:rlcornish@c...]
>Sent: Wednesday, January 30, 2002 12:30 AM
>To: Access
>Subject: [access] Re: access2000 Output to CSV file type .
>
>
>You might try going into Office Setup (Control Panel) and check to see
>what filters you installed. (Office Setup, Shared Features, Convertors &
>Filters). You may have to add CSV to the list. The CSV option appears
>on my machine.
>
>R
>
>> Does anybody know how to OutputTo a CSV file.
>> All the available formats are not what I require .
>> I am trying to create , from a form , a simple list of staff members to
>a
>> file called "Employee.xxx" where xxx is the number of the depot.
>> I have managed the last bit using a command button and actually sending
>> the file i.e. I went to record 10 (our depot 010) and created a file on
>> the default area called "Employee.010" but the file is only in the
>> following formats (*.asp),(*.xls),(*.htx, *.idc), MS-DOS Text (*.txt),
>> Rich Text Format (*.rtf), or Microsoft Data Access Page (*.html) none
>of
>> which are suitable ...... I just need a CSV output, No headers .
>
|
|
|
View Cart
