RE: ODBC error I can't explain

2004-11-16 Thread James Smith
> >That would be my interpretation of the error as well, > however the sheet > >only has 1 column and that column has only 2956 records. > > > >Any other ideas? > > > > > Still sounds like that is the problem. Although when you > look at the spreadsheet it only has one column with data in >

Re: ODBC error I can't explain

2004-11-16 Thread Stephen Moretti (cfmaster)
James Smith wrote: >That would be my interpretation of the error as well, however the sheet only >has 1 column and that column has only 2956 records. > >Any other ideas? > > Still sounds like that is the problem. Although when you look at the spreadsheet it only has one column with data in it,

RE: ODBC error I can't explain

2004-11-16 Thread James Smith
To: CF-Talk > Subject: Re: ODBC error I can't explain > > James Smith wrote: > > >I am reading an excel file with an ODBC query and I am getting the > >following error. > > > >[Macromedia][SequeLink JDBC Driver][ODBC > Socket][Microsoft][ODBC Excel >

Re: ODBC error I can't explain

2004-11-16 Thread Stephen Moretti (cfmaster)
Robertson-Ravo, Neil (RX) wrote: >Should be fairly self explanatory...you are passing too much information to >the Datasource - it is expecting say 10 fields of data and you are passing >it 11. > >Perform a data mapping to see what you should be passing. > > Wrong way around Neil. He's querying

RE: ODBC error I can't explain

2004-11-16 Thread Robertson-Ravo, Neil (RX)
Should be fairly self explanatory...you are passing too much information to the Datasource - it is expecting say 10 fields of data and you are passing it 11. Perform a data mapping to see what you should be passing. -Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent: 1

Re: ODBC error I can't explain

2004-11-16 Thread Stephen Moretti (cfmaster)
James Smith wrote: >I am reading an excel file with an ODBC query and I am getting the following >error. > >[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Excel >Driver] Too many fields defined. > >Can anyone explain this error, I am not sure why I am getting it. > > There is