View Single Post
  #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
.