Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Jul 2006
    Thanked 0 Times in 0 Posts

    Creating new field when importing data in table (2000)

    I would like to know how to automatically create a field (which contains no data) in a table when l use the "create table command, as l need to append details on to a table, and the data in the other tables is in field 1 (i.e the 2nd column to the right). I have a created a table which contains imported data but the data is in the wrong column, it need to be in the 2nd column to the right , as in the example. In the example the field which l created is called field 2. I need to do thos automatically by a query or macro , is this possible?

    Any help would be appreciated.


  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Creating new field when importing data in table (2000)

    Please don't spam the forum by asking the same question more than once. This thread is locked to avoid further duplication.

Posting Permissions

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