Re: export kwerendy do pliku csv

Article View: pl.comp.bazy-danych.msaccess

Article #137318

Back to pl.comp.bazy-danych.msaccess Previous Next

#137318

From: MaciejF
Date: Wed, 23 Nov 2016 06:25

19 lines
2344 bytes

W dniu środa, 23 listopada 2016 07:23:54 UTC+1 użytkownik MaciejF napisał:
> skorzystaj z doświadczeń Prota:
> Zmień kod w swojej procedurce:
> 
> DoCmd.TransferText acExportDelim,"Export11" , "tmpExport", fd.SelectedItems(1), True,,852
> 
> 
> Dodałem kodowanie OEM Latin2 - 852
> Zmień "Export11" jeżeli twoja specyfikacja eksportu jest inna
> 
> MF

Tutaj zmień nazwę pliku:
fd.InitialFileName = "export_" & Format(Date, "mmddyyy") & ".csv"

np.
fd.InitialFileName = "mojCSV_" & Format(Date, "Yyyymmdd") & ".csv"

MF

Technical Details

Message-ID: <a6f43a6d-e9e3-47b6-843e-bb7903bbcdcb@googlegroups.com>

Path:

mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!newsfeed2.atman.pl!newsfeed.atman.pl!goblin2!goblin.stu.neva.ru!feeder.erje.net!2.us.feeder.erje.net!news.glorb.com!p16no101092qta.1!news-out.google.com!j8ni535qtc.0!nntp.google.com!p16no101087qta.1!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail

References:

<39d994b6-e28e-4fc2-a084-f06f776fd643@googlegroups.com> <1e537968-eeb9-4b13-b50b-b20a65c94981@googlegroups.com> <5adc9bd5-02aa-431a-9da5-4436331981d0@googlegroups.com> <e2bcce68-05b7-4f32-a98d-c29be8945003@googlegroups.com> <f0871dfd-9ee2-43a6-a20a-0c3c8c7b7c9e@googlegroups.com> <efb3385e-a83b-417d-ad7c-0ecf45246ed5@googlegroups.com> <23f5c5ff-a594-4fb9-8eb3-477cd7eebce0@googlegroups.com> <499a75f3-cb1d-45d9-b7e2-40edd8cf771f@googlegroups.com> <cfdcc8ae-3636-45a6-8e98-354ced6c90c0@googlegroups.com> <042100af-c425-4d32-a758-960f0de71417@googlegroups.com>

Show Full Headers

Complete Article Headers

X-Received: by 10.36.70.136 with SMTP id j130mr812214itb.10.1479882343452;        Tue, 22 Nov 2016 22:25:43 -0800 (PST)
X-Received: by 10.157.15.143 with SMTP id d15mr111250otd.2.1479882343309; Tue, 22 Nov 2016 22:25:43 -0800 (PST)
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!newsfeed2.atman.pl!newsfeed.atman.pl!goblin2!goblin.stu.neva.ru!feeder.erje.net!2.us.feeder.erje.net!news.glorb.com!p16no101092qta.1!news-out.google.com!j8ni535qtc.0!nntp.google.com!p16no101087qta.1!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups: pl.comp.bazy-danych.msaccess
Date: Tue, 22 Nov 2016 22:25:42 -0800 (PST)
In-Reply-To: <042100af-c425-4d32-a758-960f0de71417@googlegroups.com>
Complaints-To: groups-abuse@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=213.241.94.194; posting-account=kc7ZIQoAAAB5PkdJgxjq1dd8jnBK4MVp
NNTP-Posting-Host: 213.241.94.194
References: <39d994b6-e28e-4fc2-a084-f06f776fd643@googlegroups.com> <1e537968-eeb9-4b13-b50b-b20a65c94981@googlegroups.com> <5adc9bd5-02aa-431a-9da5-4436331981d0@googlegroups.com> <e2bcce68-05b7-4f32-a98d-c29be8945003@googlegroups.com> <f0871dfd-9ee2-43a6-a20a-0c3c8c7b7c9e@googlegroups.com> <efb3385e-a83b-417d-ad7c-0ecf45246ed5@googlegroups.com> <23f5c5ff-a594-4fb9-8eb3-477cd7eebce0@googlegroups.com> <499a75f3-cb1d-45d9-b7e2-40edd8cf771f@googlegroups.com> <cfdcc8ae-3636-45a6-8e98-354ced6c90c0@googlegroups.com> <042100af-c425-4d32-a758-960f0de71417@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <a6f43a6d-e9e3-47b6-843e-bb7903bbcdcb@googlegroups.com>
Subject: Re: export kwerendy do pliku csv
From: MaciejF <maciejfr@onet.pl>
Injection-Date: Wed, 23 Nov 2016 06:25:43 +0000
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Reply to Parent Message