|
| 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
July 8th, 2008, 01:40 PM
posted to microsoft.public.access.queries
|
|||
|
|||
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
July 8th, 2008, 02:30 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
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
July 8th, 2008, 02:31 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
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
July 8th, 2008, 03:42 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
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
July 8th, 2008, 03:47 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
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
July 8th, 2008, 05:11 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
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
July 9th, 2008, 08:30 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
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
July 9th, 2008, 03:30 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
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 | |
|
|
Linear Mode
