Excel Import macro

[c3hammy]

Hi



I want to make a production counting system using a siemens logo plc this will data log the counts to an excel spreed sheet every second but can only have a maximum of 20,000 rows before it starts overwriting itself. i Would like to pull this data to access every second from the excel spreadsheet, I have to use indexing (no duplicates) on the date/time field so it does not keep pulling the same data over and over again the only problem with this is you get the attached prompt all the time that makes it impossible for me to automate it. Is there a better way of doing what i'm trying to achieve or a way to disable the pop up?

I'm new to access any help would be greatly appreciated

[JoeM]

You can suppress those warnings in a Macro or VBA using "SetWarnings".
See: https://docs.microsoft.com/en-us/off...md.setwarnings

[June7]

Perhaps:

DoCmd.SetWarnings False

' your import code

DoCmd.SetWarnings True

[c3hammy]

Thanks guys got it working