I'm using a query to export records into an excel file. My first field name is "Assignment#". When I open the excel file, the column heading is now "Assignment." Any thoughts??
Exporting a query to Excel File
Competent Performer
Windows 7 64bit 
Access 2010 32bit
I'm using a query to export records into an excel file. My first field name is "Assignment#". When I open the excel file, the column heading is now "Assignment." Any thoughts??
VIP
Windows 7 64bit Access 2010 32bit
Should not use spaces or special characters/punctuation (underscore is exception) in names. Better would be AssignmentNum or AssignmentNo or Assignment_Num.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Competent Performer
Windows 7 64bit Access 2010 32bit
OK. These field names are imported from another system. I'll keep that in mind while creating a new DB.
Exporting to formatted Excel file
Posting Permissions
Reply With Quote