Sending Values to excel using ODBC

[uoweit]

I have read through alot of posts about excel and ODBC and none that I have read seem to pertain to my situation. I am using a program called Elipse SCADA which has a built in database system using the ODBC protocol. There is very little documentaion on the Elipse software but I have named a table in my excel file and Elipse is able to see it. The only connection parameter that i can edit from the Elipse side is something called the ODBC connection string. which is currenty set to:

ODBC;DSN=Arquivos do Excel;DBQ=d:\ABM\Forno\Test.xls;DefaultDir=d:\ABM\Forno;DriverId=790;MaxBufferSize=2048;PageTimeout=50;

I am able to sucessfully connect to the excel 2003 file but when i try to write an entry to it i get and error message saying that the 'sheet is full'. I am very new to ODBC and Im wondering if there is some seting I need to enable in my excel file so that the ODBC server can write to it. Any help would be apreciated including links to some introductory documentation about using ODBC and excel.

Thanks
Adrian

 

[uoweit]

If any one is interested the problem arose because when i designated my table in excel i selected the entire column by click on the letter at the top of the page. To fix it i simply selected only the first row to create the table.