Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2005
    Posts
    313

    Unanswered: Delete Extra fields

    Hi:

    In MS Access table,
    I have 5 fields,
    V1,V2,V3,V4,V5

    and this table is converted from Excel file to Access, everytime when I get it, there are extra fields, like that:
    V1,V2,V3,V4,V5,field6,field7,...etc.

    So, how can I hold the first 5 fields only, and then delete extra fields using by VB Code?

    Please let me know how to write the VB Code, thanks.

    I don't want to delete it the table. I want to know how to write the VB code to delete them. Thanks a lot. Thanks.

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    You could create an import spec, or you could use an SELECT INTO statement to leave behind the fields you don't want, then delete the original table.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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