text export hash symbol

[LucasH]

Hi all,

Im exporting a query with a column named "FILE #" and upon export, "FILE #" becomes "FILE .". Any idea why? Is there a way around this (i tried using the "'s around text but same thing happend) besides editing the text file after export?

I can't change the column header name.

Thanks!

 

[AHJ1]

It would not surprise me if the cause is that "File" is a reserved work in Access. Try changing the name.

 

[LucasH]

can't....stupid ADP.

I ended up just inserting a row into the table before export with the column headers, that works fine.

thanks