Field name in date format (dd mmm)

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

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?

Thanks,
Kasey


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

Report •


#1
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.

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question