Results 1 to 2 of 2
  1. #1
    MartinL is offline Novice
    Windows 7 Access 2007
    Join Date
    Aug 2010
    Posts
    1

    Excel Import/Append Data (weekly)

    I am starting from scratch with very little knowledge of Access.

    I have an Excel Spreadsheet that is emailed to me weekly
    I need to append to the database weekly (cols A&B only)
    I also need to add to the database an additional field on import
    either the data in cell B7 (week number) or the import date so the week number can be calculated in a query later.

    My problem started when I imported the initial file and then tried to use append a copy feature. Access complained about the field names not matching.

    So I am stuck at 1st base.
    My data will always come into Access via spreadsheets and not user
    What can I do?

    Martin

  2. #2
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    its actually a very common requirement. import the data into a temp table. then apply your new field with an update query. then append the results into the final table.

    if the spreadsheet never varies in terms of its column names - it can be particularly easy....however one always runs into 'gotchas'...such as misinterpretation of numbers vs text and other things....you'll have to experiment.

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

Similar Threads

  1. Excel Import
    By jesleon in forum Import/Export Data
    Replies: 4
    Last Post: 08-24-2010, 07:32 AM
  2. Import Excel with SQL - again
    By tpcervelo in forum Queries
    Replies: 1
    Last Post: 08-06-2010, 08:13 PM
  3. Automate Import of Excel data
    By tpcervelo in forum Import/Export Data
    Replies: 2
    Last Post: 07-29-2010, 12:19 AM
  4. Using Import wizard to get Excel data
    By Jack Sheet in forum Import/Export Data
    Replies: 5
    Last Post: 07-16-2010, 09:44 AM
  5. VBA to open excel, import on close of excel
    By bdaniel in forum Programming
    Replies: 0
    Last Post: 03-20-2010, 02:45 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