Exporting a CSV with a Header name containing "#"

[Turn10LLC]

Hi All -

I'm attempting to export a .csv file using Access where the header file contains "File #" and "Pay #". When I export the file using either a Macro or directly selecting Export from Access' menu when the file exports "File #" and "Pay #" gets changed to "File ." and "Pay ."

Of course I can go into Notepad and change it but this shouldn't be a step in the users documentation!

I'm open to exporting it and then progamatically changing it just need automation options to do that or better yet some VBA help in making Access do what it's supposed to do rather than changing my headers!

Thanks!

 

[SkipVought]

hi,

Just out of curiosity, where does the .csv get used?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Turn10LLC]

It's for use with ADP

 

[oharab]

Try

http://access.mvps.org/access/modules/mdl0058.htm.

B.

----------------------------------------------
Ben O'Hara

We could be confused in exactly the same way, but confusion might be like Nulls, and not comparable.

 

[oharab]

Or get the latest version at

http://iridule.net/cu/index.htm

----------------------------------------------
Ben O'Hara

We could be confused in exactly the same way, but confusion might be like Nulls, and not comparable.