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

Field names on export 3
Rename fieldName and keep Excel sheet when exporting data 1
How do I run a query that displays field names and not captions 1
Subscript out of range messge while importing from Excel to append 8
Export from 2007 using Export Specification. 2
Importing an Excel file 4
Access Property sheet data missing also syntax 0
Excel Export - Field Names in First Row of Spreadsheet 18

Top