Show # sign in exporting Access query to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I show a # sign in a field name when I am exporting a query result to
Excel?

Please let me know. Thanks.
 
# is the character used to indicate a "." character.

If you use hash you should get dot

I don't think there is any way to show a # sign in a field name when you are
exporting a query result to Excel.

(david)
 
Are you using Access 2002/2003? If so, have you applied
the latest service packs? What method are you using for
exporting to Excel? I know that writing to a linked
table is disabled, but I'm not sure which other methods
are still available, so I'm curious about your experience.

(david)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

email addresses double when exporting query to excel 3
# sign in field name exported as '.' 2
Export Data from Queries in Access 2007 to Excel Spreadsheet 1
Exporting to Excel 2007 1
The Export Pound Sign or number sign 4
Export to XML - error 31532 0
Export Query to Excel 1
Export Access 2007 reports/queries to Word 2007 documents 1

Back
Top