Import Date Mask for Excel

[Jim Vincent]

Greetings All,

Hope you can help me out here. I'm trying to import from Excel but the
default date in Excel is in this format: 12/2/2005 12:49:49 AM (for
example).

What input mask can I use in Access so it will accept it? If it is a
challenge, how can I knock it down to just the date?

TIA.

[Larry Linson]

"Jim Vincent" <ga*****@aol.comwrote in message
news:11*********************@l70g2000cwa.googlegro ups.com...

Greetings All,

Hope you can help me out here. I'm trying to import from Excel but the
default date in Excel is in this format: 12/2/2005 12:49:49 AM (for
example).

What input mask can I use in Access so it will accept it? If it is a
challenge, how can I knock it down to just the date?

What trouble are you having? Just for grins, I created an Excel 2003
spreadsheet with two rows, each beginning with a date in the format you
show, and both imported just-fine-thankee into Access 2003, as a Date/Time
field. (I am using U.S. regional settings in my O/S.)

Larry Linson
Microsoft Access MVP

[Jim Vincent]

Thanks Larry,

I was able to import it if I set the format as text. It was able to
sort based on that date, so that was not a problem. However, I want to
change the format in the report so it only shows 12/2/2005, skipping
the time part. How might I go about doing that?
Thanks again.

Jim

Larry Linson wrote:

"Jim Vincent" <ga*****@aol.comwrote in message
news:11*********************@l70g2000cwa.googlegro ups.com...

Greetings All,

Hope you can help me out here. I'm trying to import from Excel but the
default date in Excel is in this format: 12/2/2005 12:49:49 AM (for
example).

What input mask can I use in Access so it will accept it? If it is a
challenge, how can I knock it down to just the date?

What trouble are you having? Just for grins, I created an Excel 2003
spreadsheet with two rows, each beginning with a date in the format you
show, and both imported just-fine-thankee into Access 2003, as a Date/Time
field. (I am using U.S. regional settings in my O/S.)

Larry Linson
Microsoft Access MVP

[Larry Linson]

"Jim Vincent" <ga*****@aol.comwrote

I was able to import it if I set the format
as text. It was able to sort based on that
date, so that was not a problem. However,
I want to change the format in the report
so it only shows 12/2/2005, skipping
the time part.

That is, IIRC, one of the formats that is a choice in the Format Property of
the TextBox -- "Short Date."

Larry Linson
Microsoft Access MVP