Converting Dates

[LAF]

I have a table in MS Access which stores a date in the Date/Time format
dd-mmm-yyyy. In my Excel spreadsheet, I have a variable which I pul
this date into. In the spreadsheet, it pulls it in the same forma
dd-mmm-yyyy. Is there a way to convert that date into a numeri
number? I want to leave the database as dd-mmm-yyyy, but have m
variable in the spreadsheet store it as numeric

 

[Frank Kabel]

Hi
try
- copy an empty cell
- select your imported data
- use 'Edit - Paste Special' and choose 'Add'

another option: try using 'Data - Text to columns'

 

[Jamie Collins]

I have a table in MS Access which stores a date in the Date/Time format,
dd-mmm-yyyy.
Is there a way to convert that date into a numeric

Change your query e.g. if it currently looks like this:

SELECT MyDateTimeCol FROM MyTable;

then change it to something a bit more like this:

SELECT
IIF(MyDateTimeCol IS NULL, 0, CDBL(MyDateTimeCol))
AS MyDateTimeNum FROM Sheet1;

Jamie.

--