Type Conversion Failure-error While Importing Excel Data

[smugcool]

HI,

I am trying to import an excel data. All the fields are geting imported properly. But i am geting error in the date field. I tried to keep the format both in excel and access very similar.But still it throws me an error of type conversion failure. Can anybody help me.

Regards
Anup

[JustJim]

HI,

I am trying to import an excel data. All the fields are geting imported properly. But i am geting error in the date field. I tried to keep the format both in excel and access very similar.But still it throws me an error of type conversion failure. Can anybody help me.

Regards
Anup

Dates are a real pain in Access aren't they? I think I remember that to import dates from Excel, they have to be in US date format "mm/dd/yy".

I'll check that and get back to you

Jim

[JustJim]

Dates are a real pain in Access aren't they? I think I remember that to import dates from Excel, they have to be in US date format "mm/dd/yy".

I'll check that and get back to you

Jim

Ooops, that appears not to be the case... Sorry!

Jim

[smugcool]

Hi,

Is there any option to avoid this error. As i got fed up doing a lot of R & D behind this problem.

[JustJim]

Hi,

Is there any option to avoid this error. As i got fed up doing a lot of R & D behind this problem.

I'll bet that there is. If you post your Excel data as well as the VBA code that's importing it, we'll have a crack at it.

Jim