DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

+ Reply to Thread
Results 1 to 2 of 2
  1. 01-06-2010 04:59 AM #1
    Talat
    Talat is offline Registered User
    Join Date
    Aug 2009
    Posts
    35

    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!
    Reply With Quote Reply With Quote
  2. 01-06-2010 09:23 AM #2
    gibra's Avatar
    gibra
    gibra is offline Registered User
    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.
    HTH
    VBCorner code: MenuCreator add-in + MenuExtended.dll - SaveToFolder add-in -
    my PSC code: CommonDialog Enhanced Callback - Enumerate Icon Resources - Network Change TCP/IP
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. How to transfer a local Access table into a remote Access database by ADO ?
    By Oscar99 in forum Database
    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, 10: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, 02:58 PM

Tags for this Thread

Bookmarks

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
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


Top DevX Stories

Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL


Sponsored Links