Prev: Does SQL Run Behind Queries?
From: Luciano on 6 Jun 2010 03:09
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
From: Jörn Bosse on 6 Jun 2010 07:36
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
From: Luc BalloonPlanning on 6 Jun 2010 11:01

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
> .
>
From: Jörn Bosse on 6 Jun 2010 12:22
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/library/aa220768%28office.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
>> .
>>

 | 
Pages: 1
Prev: Does SQL Run Behind Queries?