Access Export CSV File problems

[damc1123]

I am trying to export a CSV file from MS access that will be imported into an application that requires a field name with a "#" character in it. Specifically the fileld needs to be named "File #". The problem I am having is that the "#" is always replaced with a "." by the export program. Is there a setting somewhere that can be changed so the export program does not replace this character?

Any help on this would be much appreciated.

Thanks.

David

 

[crosmill]

Nightmare!!

The only solution I can think of for this would be to hard code the file export, where you could use the chr(number here) to get #.

It's alot of effort considering Access has the built in function, is it worth the effort?

If it is then what you'd do is create a recordset from you data and then use the FileSystemObject to write the file. I use this alot in ASP, but it all pretty much works the same way.

...mmm I supose you could write VBScript program that would open the file, count the cursor to the exact point and the replace the charachter. But thats out of my league I'm affraid, I've not really done much of that!

Let us know how you get on. I can provide some ASP examples of the File sytem Object if you'd like them.