Recent content by lcbateman3

Well thats the issue. I need to either snapshot at a set time interval. Or come up with a way for excel to write to table. I am pretty open to all options at the moment.

Hi All, I am not quite sure if what I want to do is possible or not but maybe you all can give me a hand. I have a linked table to an excel spreadsheet. The excel spreadsheet has live DDE links to an controller for a peice of equipment. This spreadsheet records the units that are dumped...

Ok, I got part of the issue figured out. I was able to update my data without issue now. Now I just have another issue with the software that is reading the database, so I am going to have to back to the drawing board on it. I'll run this by you all to see if you have any ideas. (I am open to...

Yes, I have saved the file, but it still doesn't update. It only updates when I completely close the Excel application. Acts like the file is locked...

Okay, Just figured out something. If I close the excel sheet, then it will update that linked table. That is all good and fine. My issue here now is that data it is polling is live time data (pulls via DDE from an controller on the network). So am I going have to make it, where it open and...

Okay, this is probably fairly simple, but after hours of coding, other items, I just can't wrap my head around this one. I have an Excel 2003 spreasheet that pulls data from another source. I have linked this table into an Access 2003 database. When it is first linked, everything is fine...