Problem with date when importing

D

ds

Hello! I am trying to import an excel file to access. I have managed to
import successfully. However, my date column is in the excel spreadsheet
which looks as such eg 4-Feb-09 is changed to 4/2/09 in access after it has
been imported. I have
tried to keep the date's column as text datatype or datetime datatype. But
both does not work. Hope someone could clear my doubt. Thks!! Any help is
appreciated.
 
J

Jerry Whittle

Do you live somewhere that uses DD/MM/YYYY date format or the MM/DD/YYYY
format used mostly in the USA? The Window's Regional Settings on your PC can
make a difference.

Usually keeping the field as Text in a temporary is one way to get in the
data correctly. Then you can use things like IsDate, CDate, DatePart, etc. to
get the from the temp table to the final table.

What happens when you link to the Excel spreadsheet instead of importing it?
You might have better luck with the date format that way.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top