+ Reply to Thread
Results 1 to 2 of 2

VBA : insert update delete via Excel as a database

  1. 05-17-2013, 11:12 PM #1
    Nunthapp
    Nunthapp is offline
    Registered User
    Join Date
    05-14-2013
    Location
    Bkk
    MS-Off Ver
    Excel 2003
    Posts
    1

    VBA : insert update delete via Excel as a database

    Is it possible to do an application by VBA which use excel as database?
    I have a small data but many columns on excel and would like to create an application to
    add , update ,delete . Is there any example?
    I find out only the way to append data to excel. How about delete and Update?

    Thanks ,
    Best Regards
    Nunthaphat
    Last edited by arlu1201; 05-18-2013 at 02:11 AM.
    Reply With QuoteRegister To Reply
  2. 05-18-2013, 01:03 PM #2
    nathansav
    nathansav is offline
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: VBA : insert update delete via Excel as a database

    You can query the data spreadsheet from another one, using the built in connection in Excel or connect to it via ADO using VBA and use traditional SQL on it.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

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


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1