1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Importing Excel spreadsheet into Access problem

Discussion in 'Business Applications' started by KScott, Jan 21, 2013.

Thread Status:
Not open for further replies.
Advertisement
  1. KScott

    KScott Thread Starter

    Joined:
    Jan 21, 2013
    Messages:
    2
    Greetings forum,

    I have an Access database main table that I try to update at least monthly with an Excel spreadsheet feed. The spreadsheet formatting is always the same, with occasional additions or deletions of rows...those changes are what I am trying to update the database with. The rows represent personnel and their personal information. People come and go...blah, blah, blah.

    The problem is when I run the new reports and save them in Excel. I save them in the same place and rewrite over the old file with the same file name. Then I try to import external data into the Access database using this overwritten file as an append query. It worked the first time I set it up, but when I try to use it again as a saved import, I get an invalid file name for the overwritten file. Microsoft appears to be adding a hidden appendage to the file name when I overwrite the original file.

    Has anyone had experience with this problem before?
     
  2. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    I haven't heard of this problem.
    Perhaps you could tackle it differently. I normally just import the file to a temporary table (which requires no save import) and then use an Append query to add the records to the table and then a delete query to clear the temporary table.
     
  3. KScott

    KScott Thread Starter

    Joined:
    Jan 21, 2013
    Messages:
    2
    OBP, thanks for the quick reply. I think I went this route because every time I go to do an append or update query I have to manually type in the [table.name].[field.name] for every field in the table I'm appending to, or vice versa, I forget...is that normal or am I doing something wrong? It seems to be a little too laborious.
     
  4. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    Once you have set up the temporary table and Append query they should be permanent and you can then use them as often as necessary.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Similar Threads - Solved Importing Excel
  1. NinjaGuy47
    Replies:
    1
    Views:
    323
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1086248

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice