ACCESS FEED: RE: [MS_AccessPros] Error fault from CSV file

Rabu, 05 Oktober 2011

RE: [MS_AccessPros] Error fault from CSV file

Hi Robin

That tells you the rows and columns that had errors (type conversion
failures). They probably coincide with the records showing #Num!. For
example, I bet all the #Num!s are in the Visitors column and are in rows 31,
41, 48, etc.

I don't believe you've replied to the message I posted here:
http://tech.groups.yahoo.com/group/MS_Access_Professionals/message/93424

Have you examined the file in Notepad, or checked the field properties?

Cheers,
Graham

> From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Robin Chapple
> Sent: Thursday, 6 October 2011 12:52
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] Error fault from CSV file
>
>
> Bill,
>
> Yes my response is time stamped:
>
> At 5/10/2011 07:31 PM, Robin Chapple wrote:
>
> That is the day before your query. Repeated here:
>
> Thanks Bill,
>
> That gave me seven conversion errors:
>
> Error Field Row
> Type Conversion Failure Visitors 31
> Type Conversion Failure Visitors 41
> Type Conversion Failure Visitors 48
> Type Conversion Failure Visitors 50
> Type Conversion Failure Visitors 57
> Type Conversion Failure Visitors 127
> Type Conversion Failure Visitors 811
>
> What do I read into that?
>
> Regards,
>
> Robin
>
> At 6/10/2011 04:21 AM, you wrote:
> >Robin - Did you try my suggestion? This thread is getting rather
> >long so you might not have seen it.
> >
> >Bill