Locked - problem with strings and dates

By heavey4 ·
I am having trouble figuring out how to validate some dates. I have to read them in from an excel file and put the into access. The problem is if a null value is entered for a date in the excel file. null values are allowed int the db but I can't pass them through my "insert command". Any suggestions?
All help is welcome

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

I suppose it depends how you want to deal with the nulls....

by robo_dev In reply to - pro ...

you could check the range for nulls first:

Or you could let the good ones go thru and clean up the nulls as exceptions. Here's an app that does that:

Collapse -

Thank you

by heavey4 In reply to I suppose it depends how ...

I got this problem fixed this morning but thank you very much for your swift reply.

Related Discussions

Related Forums