Can I export from Access to Excel using field names not captions?

P

Penny Green

I need to export and import data between Access and Excel but to use the
Access field names not the captions. The new version seems to default to the
Captions for the Excel column headings which makes my onward data transfer
difficult. How can I set it up to use the field names instead?
 

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

Integrating information from Word to Excel (not mail merge) 1
Autonumber field in Excel that behaves the same as Access 0
Field names on export 3
Adding Cost Field to Appointment 0
Removing double quotes from field names 0
Exporting field names 1
Merging from an Excel file with graphics 1
Link to excel table which has keys in both row and col headers: isthis possible? 0

Top