Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

text export hash symbol

Status
Not open for further replies.
LucasH

LucasH

IS-IT--Management
Oct 28, 2003
93
US
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!
 
Sort by date Sort by votes
It would not surprise me if the cause is that "File" is a reserved work in Access. Try changing the name.
 
Upvote 0 Downvote
can't....stupid ADP.

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

thanks
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Moss100
  • Locked
  • Question
Vba code I can call from a query to reformat text
Replies
8
Views
226
Moss100
Moss100
FrankMars
  • Locked
  • Question
Exporting Records to Excel 1
Replies
6
Views
261
Andrzejek
Andrzejek
AS Mughal
  • Locked
  • Question
Select Multiple Images and store their file path and image name in text fields of ms access table 1
Replies
7
Views
216
Andrzejek
Andrzejek
btamsgn
  • Locked
  • Question
How to add lines from textbox to table 1
Replies
8
Views
149
MattGreer
MattGreer
RolandR
  • Locked
  • Question
Access Rich Text Memo Field Question
Replies
1
Views
110
RolandR
RolandR

Part and Inventory Search

Sponsor

Back
Top