Question

Locked

VB.net/excel/access - 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.

3 total posts (Page 1 of 1)  
| 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 VB.net/excel/access - pro ...

you could check the range for nulls first:

http://www.ozgrid.com/forum/showthread.php?t=23136

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

http://www.4tops.com/excelimport.htm

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.

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums