Hi Robin
It seems the problem is to do with numbers in the thousands being formatted
with commas. This means that in the CSV they need to be enclosed in quotes,
so the comma doesn't signify a new field. I'm guessing that Access is
either (a) getting confused about this delineation or (b) treating the
values in quotes as text and therefore "not numeric".
Do you have any control over the creation of the CSV file? If so, could you
have it created with no comma as a thousands delimiter?
Failing that, could you email me a copy of the CSV file - or just the first
100 rows if it is large (you have my email address) and I'll see if there is
a way to define an import specification that will work for you.
Cheers,
Graham
> From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Robin Chapple
> Sent: Friday, 7 October 2011 08:57
> 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
Tidak ada komentar:
Posting Komentar