I have microsoft Access with 3000 records.. How I can insert the value "Selangor" into the field "Negeri" in one time? I tried to fill the value one by one.How to fill the value that with quick method?
Printable View
I have microsoft Access with 3000 records.. How I can insert the value "Selangor" into the field "Negeri" in one time? I tried to fill the value one by one.How to fill the value that with quick method?
UPDATE tablename SET negeri = "Selangor"
Thank you. How to run this SQL from Microsoft Access? What I mean, without run VB
Hi,
Use the sql view of microsoft access...
Greg