(UTC)
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic Import Problem (Read 366 times)
JimChet
Member
*
Offline


No personal text

Posts: 9
Location: Northern California
Joined: Mar 13th, 2006
Import Problem
Dec 17th, 2007 at 6:10am
Print Post Print Post  
I'm trying to Import 16 elements in from an EXCEL.csv file.  I get an error message.  I have no problem importing the first 12 elements.  When I attempt 13 or more, I get this error message:  Number of fields in ASCII File C:\Documents & Settings\Jim\Desktop\ToSesame.csv on line 1 does not match number specified: (16)
Am I doing something wrong?  Thanks for any help you might suggest.

Jim
  
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Import Problem
Reply #1 - Dec 17th, 2007 at 12:46pm
Print Post Print Post  
Jim,

This is usually caused either by:
1. Specifying a different number of fields to import than you actually have in your file.
2. Having something like quote marks in your data.

Take a look at the data in that thirteenth column and see if there is anything weird about it.
  
- Hammer
The plural of anecdote is not data.
Back to top
WWW WWW  
IP Logged
 
BOBSCOTT
Senior Member
Members
*****
Offline


That Darn Computer #$X#
{curse words}

Posts: 1195
Joined: Nov 22nd, 2002
Re: Import Problem
Reply #2 - Dec 17th, 2007 at 3:25pm
Print Post Print Post  
Jim,

I have had this problem when I have a blank line in my CSV file. It would work until it hit the blank spot and then give me an error. I used to just take a Excel file that was given to me and save as csv and then import. I have learned over time to quickly scroll through the csv file and look for oddities, especially empty rows.
  
Team – Together Everyone Achieves More
Back to top
 
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge