Hi Robin,
Thinking about it yet again, the problem is almost
certainly in the source file that was used to
create the .csv file.
So rather than fixing the .csv file, go back to the
data source and correct it there. That saves you
having to make corrections every time you repeat the
current process. You can also do something to make
sure that bad data can be prevented at source.
Maybe the FieldType was Text when it should have
been Integer.
Hope that helps.
Regards, Clive.
--- In MS_Access_Professionals@yahoogroups.com, "Clive" <zctek@...> wrote:
>
> Hi Robin,
>
> Alternatively, import the .csv file but specify the
> dodgy Field as Type = Text.
>
> Regards, Clive.
>
> --- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@> wrote:
> >
> > Robin-
> >
> > OK, what's in the Visitors column in rows 31, 41, 48, etc. ?? Look at the CSV
> > file in Notepad.
> >
> > John Viescas, author
> > Microsoft Office Access 2010 Inside Out
> > Microsoft Office Access 2007 Inside Out
> > Building Microsoft Access Applications
> > Microsoft Office Access 2003 Inside Out
> > SQL Queries for Mere Mortals
> > http://www.viescas.com/
> > (Paris, France)
> >
> >
> >
> > -----Original Message-----
> > From: MS_Access_Professionals@yahoogroups.com
> > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Robin Chapple
> > Sent: Thursday, October 06, 2011 1:52 AM
> > 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
> > >
> > >--- In MS_Access_Professionals@yahoogroups.com, Robin Chapple
> > ><robinski@> wrote:
> > > >
> > > >
> > > > Thanks Clive,
> > > >
> > > > My apology for the delay. I've been busy on other matters.
> > > >
> > > > I have now used the TYPE function and they are all type "1".
> > > >
> > > > Regards,
> > > >
> > > > Robin
> > > >
> > > > At 4/10/2011 08:30 PM, you wrote:
> > > > >Hi Robin,
> > > > >
> > > > >To use the TYPE function enter it in the style
> > > > >=TYPE(A1)
> > > > >where A1 is the cell number.
> > > > >
> > > > >It comes under the category 'Information'.
> > > > >
> > > > >If you can't fix it, can you upload the .csv file
> > > > >to the 2_AssistanceNeeded folder?
> > > > >
> > > > >Regards, Clive.
> > > > >
> > > > >--- In MS_Access_Professionals@yahoogroups.com, Robin Chapple
> > > > ><robinski@> wrote:
> > > > > >
> > > > > >
> > > > > > Thanks Graham,
> > > > > >
> > > > > > To test my theory I edited the CSV file and deleted the content. I
> > > > > > them added the figures. The result was the same.
> > > > > >
> > > > > > Cheers,
> > > > > >
> > > > > > Robin
> > > > > >
> > > > > > At 4/10/2011 12:13 PM, you wrote:
> > > > > > >Hi Robin
> > > > > > >
> > > > > > >You will get the #Num! error if the field is defined as
> > > numeric, but there
> > > > > > >is non-numeric data in the cell. Are you *certain* that
> > > this is not the
> > > > > > >case? Is it possible there is a problem with spaces in the
> > > field value?
> > > > > > >
> > > > > > >Best wishes,,
> > > > > > >Graham
> > > > > > >
> > > > > > > > From: MS_Access_Professionals@yahoogroups.com
> > > > > > >[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of
> > > > > Robin Chapple
> > > > > > > > Sent: Tuesday, 4 October 2011 11:02
> > > > > > > > To: MS_Access_Professionals@yahoogroups.com
> > > > > > > > Subject: [MS_AccessPros] Error fault from CSV file
> > > > > > > >
> > > > > > > >
> > > > > > > > I have a statistical report delivered as a CSV file which shows an
> > > > > > > > error, - #Num! , in a limited number of cases, 7 out of 811, when
> > > > > > > > linked to Access.
> > > > > > > >
> > > > > > > > The CSV file has all numbers recorded.
> > > > > > > >
> > > > > > > > Where do I look for a solution to the problem?
> > > > > > > >
> > > > > > > > Many thanks,
> > > > > > > >
> > > > > > > > Robin Chapple
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >------------------------------------
> > > > > > >
> > > > > > >Yahoo! Groups Links
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >------------------------------------
> > > > >
> > > > >Yahoo! Groups Links
> > > > >
> > > > >
> > > > >
> > > >
> > >
> > >
> > >
> > >
> > >------------------------------------
> > >
> > >Yahoo! Groups Links
> > >
> > >
> > >
> >
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
>
Tidak ada komentar:
Posting Komentar