I am heading out for the day so won't be able to reply for a couple hours.

mmcdonal

Hi Expert,

As shown in the Excel that the column A contains english text and localized text row by row.

The same I have to do with Access Table Name "Lemmas" which contains only one field as "Lemma" and the data in this field should like the excel data in one column A.

I don't have to put data in two feilds.

Here "Source Text" means a english strings and "Text" Means Localized Strings but not as a feild Name as you mentioned.

--
Shailesh

Then it would be:

Rs1.AddNew
Rs1("Lemma") = trn.String(x).SourceTextRs!.Update
Rs1.Update
Rs1.AddNew
Rs1("Lemma") = trn.String(x).TextRs1.Update
Rs1.Update

Within the loop.

Did that work?


mmcdonal

Hi Expert,

Great! it's as per the requirements!

Thanks,
Shailesh