How can I Modify a linked table in Access 2003?


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
    Posts
    37

    How can I Modify a linked table in Access 2003?

    Hi,

    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
    Location
    Italy - Breganze (VI)
    Posts
    120
    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, 06: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, 05:01 PM
  4. Access & SQL Server
    By David Jones in forum Database
    Replies: 0
    Last Post: 08-31-2001, 01: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
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

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