Importing Dates from Excel

[snypa]

Hi Guys

I'm trying to import date from an excel worth sheet into Access but nothing is inserted into the column. The format of the date in excel is 20090128 which is American format and I have also confirmed that the Access uses this to handle dates etc.

That data type(in the Access) table is also date but I cannot format it as date in access because it says its a negative date ???? I then gives it millions of ######'s

Could someone please advise me on how I can fix this

Thanx a lot

 

[jal]

What code are you using to do the import? You will probably need code that puts in separators such as slashmarks. In other words replace this:

20090128

with this:

2009/01/28