Linking Column Formats from Excel to Access

D

Dale

I'm trying to link some tables from Excel to Access. At
the first prompt in the "Link Spreadsheet Wizard" I
notice clearly the headers are exactly as they appear in
my Excel spreadsheet (ex., Jul-03, Aug-03, etc). When I
get to the next step that prompts me to decide whether
the "First Row Contains Column Headings" it's already
selected and again I notice the first row does indeed
have the headings as I've described before. After I
finish and open the table in Access, however, the headers
change to format (ex., F6, F7, etc.).

How do I get the headers to maintain the formats as they
are in Excel?

Thanks in advance for your assistance....
 

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

Excel does not accept text format! 0
Integrating information from Word to Excel (not mail merge) 1
Consolidation Table from Different Excel Tabs with Different Format 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
Manipulating Excel from Access 9
linking to excel, my fieldnames from excel won't import correctly 1
Excel Date Formatting 0

Top