Is it possible to export from Access to a text file using a fixed width specification and also to have a pipe delimiter between each field? I cannot work this using the specs and just wondered if it existed as code anywhere?
Yeah looks like i'm going to have to pad out the queries themselves.
I had built some VBA but couldn't get it to work fully as when inserting the pipe into some fields it was running into problems when the field was already full with characters and I couldn't work out how to increase the field size by 1 in the code below
Public Sub UpdateExport(strTable As String)
Dim db As DAO.Database
Dim rst As DAO.Recordset
Dim fld As DAO.Field
Set db = CurrentDb
Set rst = db.OpenRecordset(strTable)
Do While Not rst.EOF
For Each fld In rst.Fields
fld.Value = "|" & fld.Value
Set rst = Nothing
Thanks for the help, I'll build the pipe into the queries that produce the tables I require as suggested above