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

    Unanswered: Delete Extra fields


    In MS Access table,
    I have 5 fields,

    and this table is converted from Excel file to Access, everytime when I get it, there are extra fields, like that:

    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
    The Bottom of The Barrel
    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