converting Excel integer date format

's Computer Specifications

I am opening a text file (see thread: automate open text file) that has a
column with the Excel integer date format, the ones like this: 38855.
What is the easiest way to convert this in Access to a date like this:
dd/mm/yyyy?
Thanks for any advice.

RBS

's Computer Specifications

Figured this out now. Go into design view, selec the field and put
dd/mm/yyyy in the format edit box.

RBS

's Computer Specifications

Figured this out now. Go into design view, selec the field and put
dd/mm/yyyy in the format edit box.

RBS

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Converting complex date format to normal date format in Excel	BlackNarcissus	Microsoft Excel Misc	0	28th Jul 2011 04:28 PM
Excel keeps converting text to date format	John T via OfficeKB.com	Microsoft Excel Misc	4	12th Sep 2005 06:48 PM
Excel - Need help converting Date Format	benallred99	Microsoft Excel Misc	3	13th Aug 2004 06:41 PM
Converting an Integer into a Date	=?Utf-8?B?Sm9obg==?=	Microsoft Access	3	26th May 2004 05:47 AM
Converting Integer Month/Year to Date	Kirk P.	Microsoft Access Queries	1	13th Feb 2004 10:51 PM