Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Access will not accept a date of less than 1900 from Excel. Why
I am trying to convert an Excel spreadsheet to an Access database. I have
some dates that are in the 1800's and Access will not take them. It puts in #Num! in the space where the date is supposed to go. Can anyone tell me how to fix this problem. I have tried every kind of number format there is and when I open Access, it still does not take it. By the way, the Access database and the spreadsheet are linked so when I change the spreadsheet, it should change the database. Thanks for any help you can give me. I have wasted days on this. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Access will not accept a date of less than 1900 from Excel. Why
you have run into a limitation of excel.
read this: http://www.exceluser.com/explore/earlydates.htm "jlou" wrote: I am trying to convert an Excel spreadsheet to an Access database. I have some dates that are in the 1800's and Access will not take them. It puts in #Num! in the space where the date is supposed to go. Can anyone tell me how to fix this problem. I have tried every kind of number format there is and when I open Access, it still does not take it. By the way, the Access database and the spreadsheet are linked so when I change the spreadsheet, it should change the database. Thanks for any help you can give me. I have wasted days on this. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Access will not accept a date of less than 1900 from Excel. Why
"jlou" wrote: I am trying to convert an Excel spreadsheet to an Access database. I have some dates that are in the 1800's and Access will not take them. It puts in #Num! in the space where the date is supposed to go. Can anyone tell me how to fix this problem. I have tried every kind of number format there is and when I open Access, it still does not take it. By the way, the Access database and the spreadsheet are linked so when I change the spreadsheet, it should change the database. Thanks for any help you can give me. I have wasted days on this. Thank you for your response. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i enter a date before jan 1, 1900 into excel? | Excel Discussion (Misc queries) | |||
Exporting pre-1900 dates to Access? | Excel Discussion (Misc queries) | |||
excel date shows 01/00/1900! | Excel Discussion (Misc queries) | |||
How do I enter a date before 1900 in excel? | Excel Worksheet Functions | |||
How do I enter a date before 1900 in excel? | Excel Worksheet Functions |