ODBC error I can't explain

2004-11-16 Thread James Smith
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. -- James Smith [EMAIL PROTECTED]

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 a limit

RE: ODBC error I can't explain

2004-11-16 Thread Robertson-Ravo, Neil (RX)
: 16 November 2004 12:54 To: CF-Talk Subject: ODBC error I can't explain 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

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 the

RE: ODBC error I can't explain

2004-11-16 Thread James Smith
: 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 Driver] Too many fields defined. Can anyone explain this error, I am not sure

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
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, excel has a