Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2005
    Posts
    183

    Unanswered: Alter table in Access?

    I was wondering if I can use ALTER table in Access 2003 to append a column to a table?

    I have a procedure that imports excel sheets automatically and need to add a key column for the imported data.

    Thanks in advance,

    Kenny
    IT squid: networks, servers, firewalls, routers and I dabble a little with SQL-server and Access as well....

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Hi Kenny

    yes you can. You can create a DDL "query" or execute from code. The only complexity is that some field data types are not available using this method however some of them become possible if you execute the DDL statement through ADO.

    I have some links somewhere - I will dig them out

    HTH
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Here it is. There are three articles (basic, intermediate, advanced). This is the basic however it includes links to the other two.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  4. #4
    Join Date
    Oct 2005
    Posts
    183
    Lots of good reading... dunno where I got the impression that Access wouldn't handle basic alter table.

    But a nice page there.. Thanks

    :-)
    IT squid: networks, servers, firewalls, routers and I dabble a little with SQL-server and Access as well....

Posting Permissions

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