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