Results 1 to 2 of 2
  1. 02-28-2014, 07:43 AM #1
    marcvanderpeet12
    marcvanderpeet12 is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2012
    Posts
    23

    Input form for an excel linked access table?

    Guys,

    One of the tables in my access file is a linked excel file. I however now want to create a form with which I want people can enter information in the table. However when I try to do this, it doesn't work. Does anybody know whether it's possible to create an input form for an excel linked access table?

    Thanks in advance.

    Marc
    Reply With Quote Reply With Quote
  2. 02-28-2014, 10:35 AM #2
    June7's Avatar
    June7
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    Cannot edit Excel linked table. Can search and filter and join in queries but can't edit.
    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.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Automatic Split of Excel Table to two Access Tables that are linked...is it possible?
    By tv69 in forum Database Design
    Replies: 6
    Last Post: 01-05-2014, 11:43 PM
  2. Design Excel Form for Access Input
    By kagoodwin13 in forum Database Design
    Replies: 1
    Last Post: 11-12-2013, 03:01 PM
  3. Access table linked to excel - field size problem
    By tzmyo in forum Import/Export Data
    Replies: 1
    Last Post: 10-02-2013, 01:03 AM
  4. Repost: Dates shifting between access and linked excel table
    By lucasjkr in forum Import/Export Data
    Replies: 3
    Last Post: 11-14-2012, 03:08 PM
  5. Linking Tables within Access to a linked Excel table
    By leamas in forum Access
    Replies: 6
    Last Post: 05-16-2012, 12:43 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums