Recent content by jens

Never noticed that constant before. Many thanks! This should resolve this one but as we have to use other codepages in other areas it would be nice to be able to create a generic function that can cover all.

Thanks DJKarl this was where I was begining to head and your code has some great starters for me. What I cannot see (or more likely lack the knowledge) is how to ensure the correct codepage for a custom output such as this. Also need to write the first line as field list but have an ADO output...

Hi Chris If I can test the potential output size then I will simply reduce the parameter passed to the query thus reducing the total number of records output for that pass so that the file does not exceed 200k. At the moment a created filesize >197k just throws a warning and we have to deal...

Hi, I need to work out a sound way of determining the projected size of a csv file output. The generated file must be under 200k. Checking the created file is easy but the process is currently all wrong. I limit the output query to 140 records each pass (which brings each file in at around...

I have just downloaded it not using the standard link but under access downloads