Updating data in a linked table is not red deer dating singles

They are embedded within the analysis once imported.

1 Join Table - Join Table This table joins the 4 source tables together using various column matches.

Hey, I'm having some trouble with one of my tables not refreshing when new data is imported.

I have 6 data tables in total which are broken down as follows: 4 source tables - Source A - Source B - Source C - Source D These tables contain all the basic information i need for my analysis.

Table Def Set db = Current Db() 'delete old tables if they exit db. Execute "DROP TABLE tbl Excel Tx" 'link to Excel Workbook str Xl Tx = Nz(DLookup("Excel Tx", "tbl Output"), 0) Set tdf = db.

Create Table Def("Sheet1") str Link = "Excel 8.0; DATABASE=" & str Xl Tx tdf.

Append tdf Set db = Nothing Set tdf = Nothing End Function Here's the query that results in the error mentioned above: DELETE * FROM Sheet1 WHERE Tx Date Is Not Null AND Amount Is Not Null AND Entity_ID = 489 AND Tx Type_ID =20 AND tx Acct_ID = 91; Am I missing something? I have an Access 2003 mdb with an Excel 2003 Workbook as a linked table. Is there a work-around to be able to run action queries against linked tables? 10-4 ..I'll just scrape the data into a regular table (see code below) a couple of follow-up questions: when linking to the Excel Workbook should I use: str Link = "Excel 5.0; DATABASE=" & str Xl Tx --or-- str Link = "Excel 8.0; DATABASE=" & str Xl Tx why isn't there a Excel 11.0 option?

Append tdf Set db = Nothing Set tdf = Nothing End Function Here's the query that results in the error mentioned above: DELETE * FROM Sheet1 WHERE Tx Date Is Not Null AND Amount Is Not Null AND Entity_ID = 489 AND Tx Type_ID =20 AND tx Acct_ID = 91; Am I missing something?

Its worth noting that I recently upgraded from Spotfire 7.0 to 7.6.

Prior to this update I had similar analysis set up where I didn't experience this issue.