Results 1 to 5 of 5
  1. #1
    teirrah1995 is offline Advanced Beginner
    Windows XP Access 2002
    Join Date
    Sep 2010
    Posts
    35

    Arrow Importing from Superbase


    Hi. Just as the title says, I want to import data from a Superbase document, which I know little about, to an Access document, which has already been made. The Superbase has far too much data to be copied over manually (really, it could, but it could take months of doing an hour or two a day, which I'm too lazy for) and it can open as a table, if this helps.
    Any suggestions would be welcome.

  2. #2
    ssanfu is offline Master of Nothing
    Windows 2K Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Have you tried an append query?

  3. #3
    teirrah1995 is offline Advanced Beginner
    Windows XP Access 2002
    Join Date
    Sep 2010
    Posts
    35
    What's an append query? Thanks for the reply.

  4. #4
    ssanfu is offline Master of Nothing
    Windows 2K Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Quote Originally Posted by teirrah1995 View Post
    What's an append query? Thanks for the reply.

    An update query is a query that can insert records into a table. It is the easiest way to copy the records from the Superbase linked table to your Access table

  5. #5
    teirrah1995 is offline Advanced Beginner
    Windows XP Access 2002
    Join Date
    Sep 2010
    Posts
    35
    Great, I'll try that, thank you! If it can get all the information over in one go, I'm really grateful! That would be a huge headache to transfer.

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

Similar Threads

  1. Example Importing routine
    By pkstormy in forum Code Repository
    Replies: 0
    Last Post: 08-24-2010, 12:35 AM
  2. Need help in importing table
    By sdondeti in forum Access
    Replies: 6
    Last Post: 11-16-2009, 09:38 AM
  3. Importing vs. Linking
    By nickanderson in forum Database Design
    Replies: 2
    Last Post: 08-13-2009, 04:35 AM
  4. Importing Txt file via Vb
    By jquickuk in forum Import/Export Data
    Replies: 1
    Last Post: 04-01-2009, 08:27 AM
  5. Importing from Excel
    By joer in forum Forms
    Replies: 0
    Last Post: 03-14-2007, 02:01 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