If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Make changes to Linked Table
Hi,
I have an access table that is a linked excel table. I want to make changes (ie, add columns) to this linked table in access but I can't. I can't make changes in the excel table in excel because it doesn't belong to me. Is there any way I can add/amend the table in access? I tried creating a new table/query but it seems like a drop down column is created instead. but what i want is to have a new table that is linked to the excel linked table with some of the columns linked to the excel linked table. How do i do it? Thanks. Val |
#2
|
|||
|
|||
Make changes to Linked Table
In Addition,
I'd like the new table that is linked to the excel table to refresh itself whenever the excel table adds new rows. Rgds, Val -----Original Message----- Hi, I have an access table that is a linked excel table. I want to make changes (ie, add columns) to this linked table in access but I can't. I can't make changes in the excel table in excel because it doesn't belong to me. Is there any way I can add/amend the table in access? I tried creating a new table/query but it seems like a drop down column is created instead. but what i want is to have a new table that is linked to the excel linked table with some of the columns linked to the excel linked table. How do i do it? Thanks. Val . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Complicated Databse w/many relationships | Søren | Database Design | 7 | July 13th, 2004 05:41 AM |
Name not showing ID is | René | Setting Up & Running Reports | 11 | June 29th, 2004 01:40 AM |
Newbie? Do I use Report or Query | John Egan | New Users | 11 | June 28th, 2004 08:31 PM |
Make Table Query | Sara | General Discussion | 4 | June 14th, 2004 09:58 PM |
COMPARE THE TWO TABLES | Stefanie | General Discussion | 0 | June 4th, 2004 04:36 PM |