davidrsutton
Programmer
Afternoon.....
I know this may seem similar to the post below, but it is slightly different and a bit more of a specific problem....
I am creating a table from data imported from an Excel spreadsheet by using the Import data function in the tables window. This has been fine except that the dates that are stored in Excel are stored as a 5 digit number but formatted to show as a date (dd/mm/yyyy). When you import the dates into Access as a table, you get all the 5 digit numbers rather than the dd/mm/yyyy format which we are after.
Does anyone know of a way to convert these 5 digit date references into a normal date format in Access? Failing that, how you can convert the date formats to text/general in Excel in such a way that you keep the dd/mm/yyyy format?
We are running Access 97 and Excel 97.
I know this may seem similar to the post below, but it is slightly different and a bit more of a specific problem....
I am creating a table from data imported from an Excel spreadsheet by using the Import data function in the tables window. This has been fine except that the dates that are stored in Excel are stored as a 5 digit number but formatted to show as a date (dd/mm/yyyy). When you import the dates into Access as a table, you get all the 5 digit numbers rather than the dd/mm/yyyy format which we are after.
Does anyone know of a way to convert these 5 digit date references into a normal date format in Access? Failing that, how you can convert the date formats to text/general in Excel in such a way that you keep the dd/mm/yyyy format?
We are running Access 97 and Excel 97.
