OfficeFrustration

OfficeFrustration (http://www.officefrustration.com/index.php)
-   New Users (http://www.officefrustration.com/forumdisplay.php?f=23)
-   -   Export in cvs format (http://www.officefrustration.com/showthread.php?t=1119765)

Luciano[_3_] June 6th, 2010 08:09 AM

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

Jörn Bosse[_3_] June 6th, 2010 12:36 PM

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

Luc BalloonPlanning June 6th, 2010 04:01 PM

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
.


Jörn Bosse[_3_] June 6th, 2010 05:22 PM

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
.




All times are GMT +1. The time now is 04:59 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
OfficeFrustration.com