Please help me from putting a dent in my head....

[lcbateman3]

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. If the data changes though, Access data does not change. Even if I select refresh data. I have actually deleted the linked table, and relinked it, and it still has the old data.

Anyone have any idea?

 

[Bilbo_Baggins_Esq]

This may sound silly, but are you certain you're linked to the updated verions of the file?

One time I did something similar and spent a long time trying to figure it out, and despite having confidence I was linking to the correct file, it turned out I was not.

 

[allan57]

Are you sure linked the sheet, because if accidently imported it will not update.

 

[lcbateman3]

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 closes excel every couple of minutes (that should be interesting ) Or is there another way to do this?

Thanks!

 

[Bilbo_Baggins_Esq]

Also, are you certain the Excel file has been saved?

In previous versions, in some circumstances, links to Excel data might have shown values without the workbook having been saved.

However, since Excel 2007 has shifted to using Temp files (like Word), I'm pretty sure you have to first save the workbook.

 

[Bilbo_Baggins_Esq]

I suspect you're looking at the file needing to be saved before Access will show the updated values.

Rather than closing the Excel file, try just saving it and see if Access updates.

 

[lcbateman3]

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...

 

[lcbateman3]

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 all ideas). I have a software package that is reading the database to print barcode labels. It has a datawatch built into it, that when a new record is added, it prints the label. That is all good and fine. The issue I have is that it disregards any changes that is made to the 100 records that I already have. I am reading an array of 100 words in excel. I was hoping that I could link it to access that it would print.

The software does not support it that way. If I add a new record it does. Is there a way that when the last row in excel changes, it copys itself to a table (IE add a new record).