A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Export in cvs format



 
 
Thread Tools Display Modes
  #1  
Old June 6th, 2010, 08:09 AM posted to microsoft.public.access.gettingstarted
Luciano[_3_]
external usenet poster
 
Posts: 4
Default Export in cvs format

Hi
I already do export some reports en queries in to an
..xls/rtf/tst/pdf-format. But my webmaster want it exported in cvs format. Is
this possible?
--
Luc Ringoir
Belgium
  #2  
Old June 6th, 2010, 12:36 PM posted to microsoft.public.access.gettingstarted
Jörn Bosse[_3_]
external usenet poster
 
Posts: 20
Default Export in cvs format

Am 06.06.2010 09:09, schrieb Luciano:
Hi
I already do export some reports en queries in to an
.xls/rtf/tst/pdf-format. But my webmaster want it exported in cvs format. Is
this possible?


Hi there,

thats possible. When you´re about to start a manual export you only have
to choose the right format and setup an export specification. The you
can use this all the time.

Regards,
Jörn
  #3  
Old June 6th, 2010, 04:01 PM posted to microsoft.public.access.gettingstarted
Luc BalloonPlanning
external usenet poster
 
Posts: 1
Default Export in cvs format


HI Jörn
I export my reports (queries) in Excel via a procedure somthing like this:

Public Sub LastMinutesExport()
On Error GoTo LastMinutesExport
Dim strqryLastMinutesExport As String
Select Case strLanguage
Case "N" 'Netherlands
strqryLastMinutesExport = "qryLastMinutesPlusTariefN"
Case "F" 'France
strqryLastMinutesExport = "qryLastMinutesPlusTariefF"
Case "D" 'Deutch
strqryLastMinutesExport = "qryLastMinutesPlusTariefD"
Case Else 'English
strqryLastMinutesExport = "qryLastMinutesPlusTariefE"
End Select
DoCmd.OutputTo acOutputQuery, strqryLastMinutesExport,
"MicrosoftExcel5.0/95Workbook(*.xls)", strMapXLS, False, "", 0,
acExportQualityPrint
LastMinutesExport:
Exit Sub
LastMinutesExport_Err:
MsgBox "ErrorLastMinutesExport"
Resume LastMinutesExport
End Sub

Perhaps there is a simular way to do just the same export, but not is .xls
but in .cvs format?
(cvs: seperator of the fields is de semicolon (,) and end of a record is the
CarriageReturn)

"Jörn Bosse" wrote:

Am 06.06.2010 09:09, schrieb Luciano:
Hi
I already do export some reports en queries in to an
.xls/rtf/tst/pdf-format. But my webmaster want it exported in cvs format. Is
this possible?


Hi there,

thats possible. When you´re about to start a manual export you only have
to choose the right format and setup an export specification. The you
can use this all the time.

Regards,
Jörn
.

  #4  
Old June 6th, 2010, 05:22 PM posted to microsoft.public.access.gettingstarted
Jörn Bosse[_3_]
external usenet poster
 
Posts: 20
Default Export in cvs format

Hey,

well first you have to create a manual export and save this export
secification. I bet you mean csv-format and not cvs-format.
If you want to user your code, you have to change the exportformat to
csv and use this exportspecification. If you want to export this file
you have to use the TransferText-method.

http://msdn.microsoft.com/en-us/libr...ice.11%29.aspx

Regards
Jörn


Am 06.06.2010 17:01, schrieb Luc BalloonPlanning:

HI Jörn
I export my reports (queries) in Excel via a procedure somthing like this:

Public Sub LastMinutesExport()
On Error GoTo LastMinutesExport
Dim strqryLastMinutesExport As String
Select Case strLanguage
Case "N" 'Netherlands
strqryLastMinutesExport = "qryLastMinutesPlusTariefN"
Case "F" 'France
strqryLastMinutesExport = "qryLastMinutesPlusTariefF"
Case "D" 'Deutch
strqryLastMinutesExport = "qryLastMinutesPlusTariefD"
Case Else 'English
strqryLastMinutesExport = "qryLastMinutesPlusTariefE"
End Select
DoCmd.OutputTo acOutputQuery, strqryLastMinutesExport,
"MicrosoftExcel5.0/95Workbook(*.xls)", strMapXLS, False, "", 0,
acExportQualityPrint
LastMinutesExport:
Exit Sub
LastMinutesExport_Err:
MsgBox "ErrorLastMinutesExport"
Resume LastMinutesExport
End Sub

Perhaps there is a simular way to do just the same export, but not is .xls
but in .cvs format?
(cvs: seperator of the fields is de semicolon (,) and end of a record is the
CarriageReturn)

"Jörn Bosse" wrote:

Am 06.06.2010 09:09, schrieb Luciano:
Hi
I already do export some reports en queries in to an
.xls/rtf/tst/pdf-format. But my webmaster want it exported in cvs format. Is
this possible?


Hi there,

thats possible. When you´re about to start a manual export you only have
to choose the right format and setup an export specification. The you
can use this all the time.

Regards,
Jörn
.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:24 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.