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

Rabu, 05 Oktober 2011

RE: [MS_AccessPros] Error fault from CSV file

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