Results 1 to 2 of 2
  1. #1
    templeowls is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Feb 2019
    Posts
    305

    Correct way to import into Access

    I am very new with Access so please be gentle if I'm committing a moral sin.



    I extract info from a website that drops entries into an excel spreadsheet. I then take those entries and drop them into a table in Access. They typically map perfectly. Sometimes this website will had in random columns to the excel spreadsheet or update and have new, unneeded info slots. This screws up when I drop the info into Access (unless I notice the new columns in excel) and I need to redo.

    Is there an easier way to do this? Should I be importing it differently in anyone's opinion? I know people say you should use a form (right?) but it really is much quick just dropping it into the table, but I would like to know if this is wrong

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    If you are using Transferspreadsheet,it could be a problem.
    if you extract from the web site and save the XL file to the same name everytime, c:\temp\file2import.xlsx
    link this as an external table, make an append query to import the fields.
    then it's a 1 query import.

    If the XL file adds new fields,then the append won't fail. New fields are irrelevant.
    it will only fail if they alter the name of an imported field.

    once you set this up,the steps are:
    1 save XL file
    2 run append query
    done.

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

Similar Threads

  1. Replies: 1
    Last Post: 07-09-2017, 11:14 PM
  2. Replies: 2
    Last Post: 02-28-2017, 01:34 AM
  3. Replies: 5
    Last Post: 09-12-2014, 06:41 AM
  4. Import from Excel (was correct forum...)
    By EvileDNA in forum Import/Export Data
    Replies: 5
    Last Post: 10-16-2012, 01:48 AM
  5. Replies: 9
    Last Post: 06-26-2011, 09:14 PM

Posting Permissions

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