Field name in date format (dd mmm)

Hewlett-packard / X
November 12, 2010 at 07:42:06
Specs: Win 2003, 512

I am linking an Excel sheet in MS Access 2007 where the column headings in Excel are dates, for example 17 Aug, 18 Aug ...etc, when I view in MS Access the field names (column headings in Excel) have been converted to the number equivalent of that date, for example 40408, 40409 ... etc.

How can I get MS Access to show the Field Names as 17 Aug, 18 Aug ... and so on?


See More: Field name in date format (dd mmm)

Report •

November 12, 2010 at 10:03:53
Don't know about Access, but on the Excel side you could try making your column heading TEXT.


Report •
Related Solutions

Ask Question