By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,146 Members | 1,631 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,146 IT Pros & Developers. It's quick & easy.

Import Date Mask for Excel

P: n/a
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.

Jul 6 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a

"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
Jul 6 '06 #2

P: n/a
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
Jul 7 '06 #3

P: n/a
"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
Jul 7 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.