Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
slimjen
Yak Posting Veteran
61 Posts |
 Posted - 2012-07-11 : 22:38:51
|
| Hi all. I have a SQL SERVER 2008 backend and Access 2007 frontend. I am trying to get externa data in a table within the database. The table is linked (dbo.tbl xxxx) When I use the "Docmd Transferspreadsheet command it creates a table with the same name I want to import in instead of appending to existing table. I have tried to get the data through the get external data on the ribbon in access 2007. It goes through with no errors but when I check the table; it's blank. Never had this problem when the tables were not linked to sql. I am at a lost. Please help. Thanks |
|
|
|
|
|
docmd transferspreadsheet