I am currently trying to establish a dynamic link between an Excel table and and Access table. Working in Office XP.
I have a simple Excel sheet with info arranged in 4 columns - field heading at top of column - I have an Access table with the same fields plus additional fields. I would like to establish a link somehow so that when info is entered into the SS, it is automatically updated in the DB.
Is this possible? I'm sure it used to be in older versions of Office.
I have created a linked Excel table in Access that is dynamic ie if I update my Excel file, the linked Excel table in Access updates and visa-versa and I am now trying to create an Append Query to append this linked table to my Access table - no go - the append process seems to work but the query contains no data.
I know this is probably the simplest of questions - so hopefully someone out there can help. I've been everywhere trying to find a solution!
I'm doing this for a study assignment - due on Monday - why do I always leave these things to the last minute????
I dont remember but in this forum or in EXPERTS EXCHANGE forum I have seen exactly the same question and the answer. Review it and I will also try to search it. You have to restring your search with the word "import" or "Importing".