🚀 go-pugleaf

Hey Thanks a lot Tom.
As you said I was not naming the fields before entering data.
I named the fields in the excel sheet and then entered the data it worked
:-)

Thanks,
Elizabeth


"Tom" <tom@net.com> wrote in message news:43e7b12c@newsgroups.borland.com...
> 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.
> >>>
> >>>
> >
> >