🚀 go-pugleaf

It looks like  you're trying to enter text data in non text field, so 
check if you are inserting the correct data into the correct fields?

When entering data, name the fields in which you want to enter data, and 
then add corresponding values.

ADOQuery1->SQL->Add("INSERT INTO [Sheet1](firstName, middleName, 
lastName, age) VALUES('Luka','Gigi','Majnaric','25')


Regards




Elizabeth wrote:
> Hi,
> 
> Your solution worked. Now I want to insert a record in an excel sheet.
> The following code works when I am inserting a numeric record. e.g
> 
> ADOQuery1->SQL->Add("Insert into [Sheet1$] Values('1', '2')");
> 
>     ADOQuery1->ExecSQL();
>     ADOQuery1->Close();
> 
> But I want to insert text in an excel sheet.
> I am using the following code
> ADOQuery1->SQL->Add("Insert into [Sheet1$] Values('A', 'B')");
> 
>     ADOQuery1->ExecSQL();
>     ADOQuery1->Close();
> 
> 
> But I get a "datatype mismatch error".
> Has anyone any solution how to do it ?
> 
> Thanks,
> Elizabeth.
> 
> 
> 
> 
> "Tom" <tom@net.com> wrote in message
> news:43e39813$1@newsgroups.borland.com...
>> ADOQuery1->SQL->Add("INSERT INTO TableName (FieldName1,FieldName2,...)
>> VALUES ('Value1','Value2',...)");
>> ADOQuery1->Open();
>>
>>
>> Elizabeth wrote:
>>> Hi All,
>>>
>>> I want to insert a record in MS access database using TAdoQuery.
>>> Has anyone any idea how to do it ?
>>>
>>> thanks,
>>> Elizabeth.
>>>
>>>
> 
>