|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
Writing Text Files with Access 97
Hi All,
I'm trying to output a field of an Access form as a text file, using the following: Private Sub OutputTxtfile_Click() Dim strFilename As String strFilename = strFilename & Me.Issue_Number strFilename = strFilename & ".sh" Open strFilename For Output As #1 Write #1, Me.Script Close #1 MsgBox ("Textfile " & strFilename & " written to Desktop") End Sub It works fine, except the text in the file is surrounded by double quotes and any double quotes in the textfile are doubled up, ie: "sqlplus -s $1 1> /dev/null <<endsql -- Identify LAHRA Cancelled Claims -- IK created 13/12/2002 (CANCLAIM) -- IS rewritten for iWorld tables 29/03/2003 - bhb001.sh CLEAR COLUMNS CLEAR BREAKS Clear Computes TTITLE OFF BTITLE OFF COLUMN ""TODAY"" NOPRINT NEW_VALUE REPDATE Column ""Claim"" format a9 Column ""Name"" format a20 Column ""Property Address"" format a50 etc..... " (note to clear up any confusion, the actual text I am outputting is OracleSQL) Can anyone tell me how to stop the text from having these changes made? Thanks |
|
#2
|
|||
|
|||
|
Use the Print #1 command instead of the Write #1
The you won't have the quotes ![]() |
|
#3
|
|||
|
|||
|
Thanks very much
You've come up with the goods for me again! Many thanks.
![]() |
![]() |
| Viewing: Dev Articles Community Forums > Databases > Microsoft Access Development > Writing Text Files with Access 97 |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|