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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|