Pipe Delimited export

[gselliott]

I am wanting to export a query to a text file which is Pipe delimited

e.g. 01|AD07 |111|310502| |310502|

I have managed to set it up so it will export the query to a basic txt file that is comma delimited but not sure how to make it Pipe delimited.
Any ideas?

Any help would be appreciated.

Thanks

 

[Shadez]

Heres somthing to try

in VBA

dim rs as adodb.recordset

rs.open "Select * From Table",Currentproject.connection
if not rs.eof then 'is there any data
open "Somefile" for output as #1
put #1,,rs.getstring(,,,"|",vbcrlf)
close #1
end if
rs.close


I suggest u look getstring up in the help. can remember the exact syntax


ShadeZ

 

[gselliott]

Thanks for your ideas i'll give them a go!