data is not refreshed when importing from Excel

[pontus]

Hi,

I'm using the transferdatabase command to import data
from Excel. This has worked flawlessly until today, when
suddenly I get the same data imported again and again,
altough it has "visually" totally changed in Excel. The
only way to get around it is to close down the Excel file
and re-open it. This is however not very practical for me
since I'm going between the programs all the time.

Is there any way I can enforce that the data is updated
every time (in Excel or Access), so I don't have to close
Excel to get it refreshed

Thanks,

 

[Ken Snell [MVP]]

Use TransferSpreadsheet to import data from EXCEL.