I need to export the result of q query to a text file. but the trick is that i need to limit each line by 150 character max. i think that i need to keep a counter of what i'm adding to the file. but any idea how???
thank you very much

I am not sure why you need to limit this, but you can do this by putting all the fields in your query into a variable for the line, and then passing the variable like this:

WriteLine Left(stMyVariable, 150)



mmcdonal

If you have the field names of the query, and the query name, and the text file name, we can help you write this. This should take about ten minutes.

Are you using ADO or DAO?


mmcdonal

thank you for responding. yes i do have all of these.
i'm using DAO.
I apreciate your help. buti don't need to only chop off the end fothe line. what i need is to make sure that the line is only 150 characters long and that the fields within the line match up with their predefined lengths. so that if they're less than a certain length we need to add nulls and if they are more then we need to chop off the extras.