Results 1 to 4 of 4

Thread: [RESOLVED] How to fill the records?

  1. Feb 7th, 2008, 08:51 AM #1
    matrik02
    matrik02 is offline

    Thread Starter
    Frenzied Member
    Join Date
    Feb 2007
    Location
    Malaysia
    Posts
    1,370

    Resolved [RESOLVED] How to fill the records?

    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?
    Reply With Quote Reply With Quote
  2. Feb 7th, 2008, 09:12 AM #2
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: How to fill the records?

    UPDATE tablename SET negeri = "Selangor"
    Reply With Quote Reply With Quote
  3. Feb 7th, 2008, 09:14 AM #3
    matrik02
    matrik02 is offline

    Thread Starter
    Frenzied Member
    Join Date
    Feb 2007
    Location
    Malaysia
    Posts
    1,370

    Re: How to fill the records?

    Thank you. How to run this SQL from Microsoft Access? What I mean, without run VB
    Reply With Quote Reply With Quote
  4. Feb 7th, 2008, 11:59 PM #4
    KGComputers
    KGComputers is offline
    Frenzied Member KGComputers's Avatar
    Join Date
    Dec 2005
    Location
    Cebu, PH
    Posts
    2,024

    Re: [RESOLVED] How to fill the records?

    Hi,

    Use the sql view of microsoft access...

    Greg
    CodeBank: VB.NET & C#.NET | ASP.NET
    Programming: C# | VB.NET
    Blogs: Personal | Programming
    Projects: GitHub | jsFiddle
    ___________________________________________________________________________________

    Rating someone's post is a way of saying Thanks...
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width