RE: [MS_AccessPros] Error fault from CSV file

 

Robin-

I can't tell from that display where a row begins or ends and which "column" is
the Visitors column.

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 9:57 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Error fault from CSV file

John,

My apology for the delayed responses. As you are aware I am involved
with a not-for-profit organisation and my team of 'helpers' has been
reduced to 40% by hospitalisations and overseas trips. The workload is immense.

To answer your question.

I have included one row each side of the suspect lines:

,File,Hits,Incomplete Requests,Visitors,Bandwidth (KB),,
30,http://www.rotary9790.org.au/ 4a/trf/ftp/chogm.pdf,189,0,159,"1,195",,1
31,http://www.rotary9790.org.au/
4a/yex/ftp/yexlongtermappn.pdf,"3,388","2,264",143,"195,137",,1
32,http://www.rotary9790.org.au/
4a/pr/ftp/newsletteraug.pdf,728,589,139,"138,941",,1
40,http://www.rotary9790.org.au/
4a/admin/ftp/fellowshipschairdirectoryjan2011.pdf,224,2,124,"36,708",,1
41,http://www.rotary9790.org.au/
4a/int/ftp/fellowshipadvancermay2011.pdf,"1,135","1,005",122,"125,188",,1
42,http://www.rotary9790.org.au/ 1011/ftp/march.pdf,238,31,122,"181,463",,1
49,http://www.rotary9790.org.au/ 1011/ftp/july.pdf,206,31,111,"236,105",,1
50,http://www.rotary9790.org.au/
info/ftp/mop2010.pdf,"5,070","2,644",110,"190,299",,1
51,http://www.rotary9790.org.au/
4a/trf/ftp/phfrecogandtferrequest.pdf,394,73,108,"27,904",,1
56,http://www.rotary9790.org.au/
1011/conf/ftp/febnewsletter.pdf,375,5,98,"26,879",,1
57,http://www.rotary9790.org.au/ clubs/bulletins/ftp2/
diamondcreek.pdf,"2,485","2,054",98,"214,748",,1
126,http://www.rotary9790.org.au/ 1011/ftp/december.pdf,736,314,56,"77,220",,1
127,http://www.rotary9790.org.au/
info/ftp/clubpresidentsmanual.pdf,"3,361","2,637",56,"258,542",,1
128,http://www.rotary9790.org.au/ forms/ftp/0910dataform.pdf,78,1,56,"3,776",,1
810,http://www.rotary9790.org.au/
0910/ftp/lifelinebookingform.pdf,1,0,1,"1,111",,1
,Total,"105,329","41,099",N/A,"20,130,092",,

I cannot see a consistency. An obvious problem with line 811 which is
ignored in the report because I take my own totals.

Regards,

Robin
At 6/10/2011 05:01 PM, you 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
>
>
>
>
>
>------------------------------------
>
>Yahoo! Groups Links
>
>
>

------------------------------------

Yahoo! Groups Links

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (21)

Recent Activity:

• New Members 7
• New Files 1

Visit Your Group

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___