Results 1 to 6 of 6
  1. #1
    jasonbarnes is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Dec 2010
    Location
    NC
    Posts
    56

    Repetitive Import Problem.

    I'll try my best to explain how I need my import to function...

    I have table 1 which looks like this in terms of design
    AutoNumber AKAName CorrectedName DateAdded


    AutoNumber is mainly here to be able to check back to the excel import file that the correct number of records is being used.

    Every import must wipe the table, keep the design/form, and then import the new data. I thought I could do a CurrentDB.Execute "DELETE * FROM TABLE" to wipe it clean. Then DoCmd.SavedImportExport. The problem I have is that the only saved import/exports create a new table or append. When you try to save an append it picks up all the extra columns you have to clean out during the import. Append doesn't give you the option you get when you make a new table.



    Suggestions?

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    Quote Originally Posted by jasonbarnes View Post
    When you try to save an append it picks up all the extra columns you have to clean out during the import.
    that doesn't make a lot of sense to me. Aren't append-type imports supposed to just throw the data into a table that already exists?

    Yes, I think so. If that is so, you should have no problem running a saved procedure like this.

  3. #3
    jasonbarnes is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Dec 2010
    Location
    NC
    Posts
    56
    The regular import makes you define the new table.

    I want to do the append to get around this since I want to keep my same table. However I want to wipe all the old data first.

    Thinking I should wipe it with a DELETE query. Then do some fancy RecordSet import and forget the whole saved import/export

  4. #4
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    I think you're missing it, Jason. I just told you that you can append it through the wizard. See attached. It doesn't get any more complicated than that, sir.

  5. #5
    jasonbarnes is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Dec 2010
    Location
    NC
    Posts
    56
    I don't know.. Seems to work.

    1 more question...

    Append will completely over my old table with all the new... or attach it to the end. It seems to be overwritting it as I wanted but I was under the other assumption.

  6. #6
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    "append" means to add to the end of an existing data set. if it's deleting the old data, you're probably mistakenly running your delete command in code still.

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

Similar Threads

  1. Import from .CSV or .TXT
    By accesscoding in forum Import/Export Data
    Replies: 4
    Last Post: 02-12-2011, 06:05 AM
  2. Import Row 1 Only on a .txt File
    By newbie in forum Import/Export Data
    Replies: 2
    Last Post: 02-08-2011, 08:23 AM
  3. Replies: 2
    Last Post: 06-14-2010, 03:25 PM
  4. CSV vs XLS Import
    By Betty Boop in forum Import/Export Data
    Replies: 1
    Last Post: 10-27-2009, 07:10 AM
  5. How would I import something like this?
    By Insyderznf in forum Import/Export Data
    Replies: 13
    Last Post: 08-10-2009, 05:18 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