Importing from csv stopping

[McDimwitty]

Thanks to the super moderator, I was greatly helped. I am reusing his code to read from a delimited text file and place the values into the table.

This is what he wrote:

http://www.access-programmers.co.uk/forums/showpost.php?p=639755&postcount=5

I ran into a snag. though.

I have 37 fields / columns in my csv file. One of them is a number and I want it to be used as a number. The problem, I believe, is when this number is missing from the row, the importing stops.

I checked and it's not required as a field in my table definition. What if I want some rows to have a blank for this field? Do I need to have this field defined as text?

=-= Mr McDimwitty =-=

 

[RuralGuy]

A numerical field is *always* a numerical field but a text field can contain a ZeroLengthString (ZLS) "". It is simple to convert a "text" number back to a number.

 

[McDimwitty]

That tidbit of information is going to save me a ton of time and frustration. I can convert these number fields to string in no time and then I can get to the rest of the application.

Just so you all know, I appreciate a forum like this more than you know. Books and documentation are crucial, but there always are things that come up that these resources don't really cut it. When we lack experience, we don't even know what questions we should ask or what to look up. It helps tremendously to be able to give a specific task that I need to do and get answers. After that, I slowly catch on and can apply it to other tasks.

I am sure all of you are aware of this, though. I know you all are busy, but I want to thank you (plural) for spending time doing this.

Who knows? Maybe I will have to come up with a new handle. Naaaaah.

=-= McDimwitty =-=

A numerical field is *always* a numerical field but a text field can contain a ZeroLengthString (ZLS) "". It is simple to convert a "text" number back to a number.

 

[RuralGuy]

Glad we could help.