DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: How can I Modify a linked table in Access 2003?

  1. #1
    Join Date
    Aug 2009

    How can I Modify a linked table in Access 2003?


    I have a linked (excel) table which I need to modify the data type of one of its fields. Can this be done? If so, how do I do it? Trying to change it in design mode says it can't be done.

    I am using Access 2003.

    Many thanks and Happy New year!

  2. #2
    Join Date
    Mar 2009
    Italy - Breganze (VI)
    You can't modify data FROM database, but you can FROM Excel.
    Changes made in Excel will be reflected in linked table.

Similar Threads

  1. Replies: 2
    Last Post: 09-29-2006, 05:23 PM
  2. How to delete table from Access 97 database table
    By software_develo in forum Database
    Replies: 1
    Last Post: 01-31-2006, 11:58 PM
  3. Delete & Copy Access table thru VB
    By Sinni in forum VB Classic
    Replies: 0
    Last Post: 05-29-2002, 04:01 PM
  4. Access & SQL Server
    By David Jones in forum Database
    Replies: 0
    Last Post: 08-31-2001, 12:22 PM
  5. Access mdb as linked server
    By Werner Zoller in forum authorevents.vieira
    Replies: 3
    Last Post: 01-24-2001, 03:58 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
HTML5 Development Center
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center