Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Export form to CSV file - HELP

0 views
Skip to first unread message

Vic

unread,
Dec 10, 2002, 4:40:03 PM12/10/02
to
Hello,

Can anyone provide an example of how to export a forms data to a CSV file
using the OutputTo method?
I can export to the canned formats html, txt, xls, etc with no problem.
I'm using Access XP.

TIA


Test

unread,
Dec 10, 2002, 5:02:44 PM12/10/02
to
Just seeing how it work ....

>.
>

Graham Mandeno

unread,
Dec 10, 2002, 5:30:10 PM12/10/02
to
Hi Vic

A CSV file is simply delimited text. Just export exactly as you would to a
text file (using TransferText) but name the file Something.CSV.
--
Good Luck!
Graham Mandeno [Access MVP]
Auckland, New Zealand

Return mail address is invalid in a vain attempt to reduce spam.
Feedback is welcome at: gra...@mvps.org
Please post new questions or followups to newsgroup.

"Vic" <NOSPAM@NOSPAM> wrote in message news:#1YDjUJoCHA.2440@TK2MSFTNGP10...

Van T. Dinh

unread,
Dec 10, 2002, 6:26:00 PM12/10/02
to
CSV files are just Text files as far as Access concerns.

I normally export data from Tables / Queries and use either File / Export
through the Access interface or the TransferText Action / Method (Macros /
VBA).

However, if you want to export the data bound to the Form, try the Text or
Excel format.

--
HTH
Van T. Dinh
MVP (Access)


"Vic" <NOSPAM@NOSPAM> wrote in message news:#1YDjUJoCHA.2440@TK2MSFTNGP10...

Vic

unread,
Dec 10, 2002, 6:48:10 PM12/10/02
to
Graham -

Thanks for your response.
Does the TransferText suuport exporting form data? The helper syntax
references a table name, not an object name. Also, any help on what a
'Specification file' is, if indeed this option will work with a form?

TIA

"Graham Mandeno" <Graham....@nomail.please> wrote in message
news:#Qh3vuJoCHA.1224@TK2MSFTNGP08...

Vic

unread,
Dec 10, 2002, 6:52:37 PM12/10/02
to
Van,

Thanks for the response.
I have tried the excel and text formats which work, just not as desired.
The text output is:

| txtPONumber | PartNumber | PartDescription
| Qty |
----------------------------------------------------------------------------
------------------
| FileUploadTest2 | 30030424 | 4-1/2 X 1/8 X 7/8 T27 A36 FLEX |
6 |
|---------------------------------------------------------------------------
-------------------
| FileUploadTest2 | 30037102 | 6 X 3/4 X 1 T1 60/80 MEDIUM |
5 |
----------------------------------------------------------------------------
------------------

While this could be made to work with my application - it makes parsing out
the data a bit more involved.

TIA

"Van T. Dinh" <VanThi...@PlseUseNewsgroup.bigpond.com> wrote in message
news:eftQUOKoCHA.2312@TK2MSFTNGP08...

John Vinson

unread,
Dec 10, 2002, 7:51:10 PM12/10/02
to
On Tue, 10 Dec 2002 18:48:10 -0500, "Vic" <NOSPAM@NOSPAM> wrote:

>Graham -
>
>Thanks for your response.
>Does the TransferText suuport exporting form data? The helper syntax
>references a table name, not an object name. Also, any help on what a
>'Specification file' is, if indeed this option will work with a form?

A Form *doesn't contain data*. It's a window which *displays* data.
Try exporting from a Query with the same criteria as the form's
recordsource and/or filter.


John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

Van T. Dinh

unread,
Dec 10, 2002, 8:14:10 PM12/10/02
to
I prefer the TransferText Method as it is more flexible than OutputTo. If I
need something special I use the TextStream Method such as Print (to a Text
File). The TextStream will need a bit of coding.

Suggest you try the TransferText Method.

--
HTH
Van T. Dinh
MVP (Access)

"Vic" <NOSPAM@NOSPAM> wrote in message news:utXAoeKoCHA.1612@TK2MSFTNGP10...

Vic

unread,
Dec 11, 2002, 7:45:56 AM12/11/02
to
Thanks Van

"Van T. Dinh" <VanThi...@PlseUseNewsgroup.bigpond.com> wrote in message

news:uvvLwKLoCHA.2388@TK2MSFTNGP08...

Vic

unread,
Dec 11, 2002, 7:46:41 AM12/11/02
to
Thanks John - I will put your suggestion into practice.


"John Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message
news:iu2dvukujvilfnod9...@4ax.com...

0 new messages