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
|
|||
|
|||
append to a linked excel table
I have a excel spreadsheet linked to an access database when I try to append
a query to the excel table everything seem to work fine but when I look at the table no data has been appended. I recive no errors (I can copy and paste data to the excel table) Anyone know what could be wrong? Thanks octet |
#2
|
|||
|
|||
append to a linked excel table
A linked table is an *external* source. You can add extra records to records that don't exist within Access. "Octet32" wrote: I have a excel spreadsheet linked to an access database when I try to append a query to the excel table everything seem to work fine but when I look at the table no data has been appended. I recive no errors (I can copy and paste data to the excel table) Anyone know what could be wrong? Thanks octet |
#3
|
|||
|
|||
append to a linked excel table
I meant you *cannot* add extra records. "Octet32" wrote: I have a excel spreadsheet linked to an access database when I try to append a query to the excel table everything seem to work fine but when I look at the table no data has been appended. I recive no errors (I can copy and paste data to the excel table) Anyone know what could be wrong? Thanks octet |
#4
|
|||
|
|||
append to a linked excel table
thanks
"Octet32" wrote: I have a excel spreadsheet linked to an access database when I try to append a query to the excel table everything seem to work fine but when I look at the table no data has been appended. I recive no errors (I can copy and paste data to the excel table) Anyone know what could be wrong? Thanks octet |
#5
|
|||
|
|||
append to a linked excel table
If you are adding new information in access that would be appended to the spreadsheet I can only suggest that you create a union query that puts them together and create a make-table query. "Octet32" wrote: thanks "Octet32" wrote: I have a excel spreadsheet linked to an access database when I try to append a query to the excel table everything seem to work fine but when I look at the table no data has been appended. I recive no errors (I can copy and paste data to the excel table) Anyone know what could be wrong? Thanks octet |
#6
|
|||
|
|||
append to a linked excel table
Because of a lawsuit lost by Microsoft about 2 or 3 years ago, the ability to
update data in Linked Spreadsheets had to be removed. The work around would be to import the spreadsheet data into a table. Append the new records to the Access table, and export the table back to Excel. -- Dave Hargis, Microsoft Access MVP "Octet32" wrote: thanks "Octet32" wrote: I have a excel spreadsheet linked to an access database when I try to append a query to the excel table everything seem to work fine but when I look at the table no data has been appended. I recive no errors (I can copy and paste data to the excel table) Anyone know what could be wrong? Thanks octet |
#7
|
|||
|
|||
append to a linked excel table
Do you have a news link to that? "Klatuu" wrote: Because of a lawsuit lost by Microsoft about 2 or 3 years ago, the ability to update data in Linked Spreadsheets had to be removed. The work around would be to import the spreadsheet data into a table. Append the new records to the Access table, and export the table back to Excel. -- Dave Hargis, Microsoft Access MVP "Octet32" wrote: thanks "Octet32" wrote: I have a excel spreadsheet linked to an access database when I try to append a query to the excel table everything seem to work fine but when I look at the table no data has been appended. I recive no errors (I can copy and paste data to the excel table) Anyone know what could be wrong? Thanks octet |
#8
|
|||
|
|||
append to a linked excel table
Here are a few.
http://www.eggheadcafe.com/forumarch...st25339373.asp http://support.microsoft.com/kb/904953/en-us http://support.microsoft.com/kb/904018/ -- Dave Hargis, Microsoft Access MVP "scubadiver" wrote: Do you have a news link to that? "Klatuu" wrote: Because of a lawsuit lost by Microsoft about 2 or 3 years ago, the ability to update data in Linked Spreadsheets had to be removed. The work around would be to import the spreadsheet data into a table. Append the new records to the Access table, and export the table back to Excel. -- Dave Hargis, Microsoft Access MVP "Octet32" wrote: thanks "Octet32" wrote: I have a excel spreadsheet linked to an access database when I try to append a query to the excel table everything seem to work fine but when I look at the table no data has been appended. I recive no errors (I can copy and paste data to the excel table) Anyone know what could be wrong? Thanks octet |
Thread Tools | |
Display Modes | |
|
|