Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Creating Txt files without "" 1

Status
Not open for further replies.

Taff07

MIS
Jul 18, 2001
160
GB
Hi,

I`m creating a text file, using a number of string variables as the source information. Does anyone know how I can get the "" surrounding each output line to be omitted when writing to the text file. I have used the following method to create and populate the text file.

----------------------------------------------------------
Open prefile For Output As #1

Write #1, "1" & Chr(9) & Format(Now(), "dd-mm-yyyy")

Write #1, rst!Field.Value & Chr(9) & rst!field2.Value & Chr(9) & rst!Month

Close #1
----------------------------------------------------------
Any help would be gratefully appreciated.

Thanks

Ian
 
Use Print #1 instead of Write #1 Jamie Gillespie
j-gillespie@s-cheshire.ac.uk
 
Thanks Jamie,

Thats done the trick perfectly. I think I need a break, I normally use print but for some reason I changed and was to blind to see :)

Thanks again
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top