Results 1 to 6 of 6
  1. #1
    justphilip2003 is offline Competent Performer
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2013
    Location
    Ohio
    Posts
    125

    Form & Table Export/Import Question

    My experience was gain with Access 2003 but I now have Access 2012 with low experience level in it! I would like to know if it's possible to export a form and a table from a development DB and import it to another DB? If yes, how please! TIA Phil

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,641
    Don't understand the issue. Import of objects from another db is not a new feature. Use the Import/Export wizard.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    justphilip2003 is offline Competent Performer
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2013
    Location
    Ohio
    Posts
    125
    I thought it wasn't new, but my familiarity in Access 2010 ribbon navigation is not up to the task. Nor can I find the wizard! Under the "External Data" Ribbon Tab I see "Saved imports" and "Saved exports" but no place to create an export. I do believe Access 2003 was friendlier. Phil

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,641
    Is the database a web design? Or is it an accde file? A normal accdb file will have Import and Export sections on the External Data tab.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    justphilip2003 is offline Competent Performer
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2013
    Location
    Ohio
    Posts
    125
    First, I stumbled upon the answer; I succeeded in importing the Table. I fear just clicking buttons when I am not sure what the end results will be. Second I need an Access dictionary to understand commonly used terms like "ACCDE"! In my case it is not a web application, therefore I conclude it is an accde file?! Also an error codes table would be nice to have. Thanks for your responses. Phil

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,641
    Look at the file in Windows Explorer. Is the file name extension accdb or accde?

    Correction, in Access 2010 they are "Import & Link" and "Export" sections on the External Data tab.

    A table of what error codes? There would be so many!
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. SendObject Export CSV and Import CSV
    By DetrieZ in forum Import/Export Data
    Replies: 2
    Last Post: 09-19-2012, 04:52 PM
  2. Import/Export table with field using multiselect combo box
    By celiowin in forum Import/Export Data
    Replies: 7
    Last Post: 04-04-2012, 02:25 AM
  3. export/import by email
    By sue tang in forum Import/Export Data
    Replies: 5
    Last Post: 03-14-2012, 04:41 PM
  4. Replies: 22
    Last Post: 09-06-2011, 11:34 AM
  5. An import question above the table structure
    By Shag84 in forum Import/Export Data
    Replies: 2
    Last Post: 08-20-2009, 12:21 PM

Tags for this Thread

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