Results 1 to 3 of 3

Import (?) new data in table with different order/collums...

  1. #1
    Loloboy is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Jan 2017
    Posts
    1

    Question Import (?) new data in table with different order/collums...

    Hi there!

    I am new here and quit new to access.
    Hope my englisch is well enough to explain the "problem".

    I have a non relational database with several lists (tables)
    People make reservations for new tagnumbers (equipment, instruments).

    At the end of the project they export those records to an excelfile to fill in the extra info.
    I made a query for that to filter their numbers using a field with a projectnumber.


    I then import the list and all fields containing the correct data.

    BUT...
    Not all fields must be filled in, some are there just not to loose old data but are not used anymore.
    Therefor i sorted the fields in the query in a different way, they just need to fill in the first xx fields in every record.
    Names of the columns did not change.

    BUT now i can't import the data anymore since the order is different.

    Question:
    is there a way that acces looks at the columnnames in stead of the order for import?

    Kinds regards!

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    4,329
    You'd have to supply an example.
    columns should NOT change, only the data in them.

  3. #3
    aytee111 is online now Competent At Times
    Windows 7 32bit Access 2013 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    1,668
    You can import the Excel file to a temporary table, then use an append query which will then use the column names.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. How to import data to the back end table.
    By kacocal in forum Import/Export Data
    Replies: 6
    Last Post: 02-15-2016, 11:04 AM
  2. Replies: 13
    Last Post: 01-25-2016, 12:36 PM
  3. Import(copy) data from another table
    By tazzzz in forum Import/Export Data
    Replies: 16
    Last Post: 09-17-2015, 10:55 AM
  4. Possible to Import data and replace some, but not all, in table?
    By IncidentalProgrammer in forum Import/Export Data
    Replies: 2
    Last Post: 02-17-2015, 08:30 AM
  5. Import csv file - Column order limitations
    By gg80 in forum Import/Export Data
    Replies: 6
    Last Post: 04-06-2014, 09:21 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums