spreadsheet import

[Jen0dorf]

Hi



importing a spread sheet and have a column labelled

Date of Baptism

the entries are in the format 09-oct and 26-Nov ( have no idea why)

If I import them into access the field is shown as 42286

so I went back into excel and made sure the cell format was text

When I do that in the excel spreadsheet the value changes to 42286

What's the best way to approach this ?


The field properties in the database are text I seem unable to find out the format of the excell cell

thanks
Ian

[CJ_London]

date datatypes are numeric

42286 represents the day and that is how it is stored in access - just format the field as a date - it is 9th October 2015

if you see something like 42286.23456, the bit after the decimal point represents the time expressed a time in number of seconds divided by the number of seconds in a day (86400)

format properties are not exported/imported - only values are, when you see a date 'successfully imported as a date' it is still a number - just been formatted correctly

[Jen0dorf]

Hi

thanks for the assist

problem is that the year is not 2015 could be any year from 1837 on so I wanted to import it into access as it was shown in the spreadsheet

ie 09-Oct


Off to do some thinking

cheers

Ian

[CJ_London]

as it was shown in the spreadsheet

ie 09-Oct

so in access, format the date as dd-mmm

[Jen0dorf]

muchly thanks - that did it

Ian