Results 1 to 2 of 2

automate importing access

  1. #1
    mcchung52 is offline Novice
    Windows XP Access 2003
    Join Date
    Jan 2012
    Posts
    15

    automate importing access

    Hi everyone,
    I need to import a flat database (excel) of 10 columns to an existing Access database, linked with relationships, though contains no data


    so far. It was initially set up with Excel but now needs to be ported
    to a safer and more stable platform. It now contains about 70k rows.
    I think I need to import it row by row because as I'm importing I need to
    drop the data into its corresponding table then get the id then
    enter some of remaining data into another table and do that couple times
    into another table.
    I looked into doing this with queries or series of queries but couldn't
    figure it out. So should I do this with VBA? or are there another ways?
    Any help would be appreciated. Thanks.

  2. #2
    mcchung52 is offline Novice
    Windows XP Access 2003
    Join Date
    Jan 2012
    Posts
    15
    Please disregard this post. I now see a relevant forum.

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

Similar Threads

  1. Automate report on ACCESS
    By Schoolo in forum Database Design
    Replies: 1
    Last Post: 12-18-2011, 02:11 AM
  2. Automate Access Queries
    By andreala in forum Queries
    Replies: 5
    Last Post: 08-23-2011, 06:01 PM
  3. Automate sending SMS form MS Access
    By Johan in forum Programming
    Replies: 8
    Last Post: 04-15-2010, 12:51 AM
  4. Automate Excel Import to Access Related Tables
    By KramerJ in forum Programming
    Replies: 6
    Last Post: 04-04-2009, 04:24 PM
  5. How to automate a access query ... Help me
    By kusamharsha in forum Programming
    Replies: 0
    Last Post: 02-25-2009, 09:44 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