Search results

I wrote a function that runs immediately after the saved import finishes, which removes all indexes and primary key settings (as set incorrectly by Access during the import process), and then using VBA's XML library it then parses the XML config (obtained by the command quoted in the code...

I have a table in Access that contains a list of file names and their modified dates, which is used to check if a certain file in a filing system has changed. The file modified date field is populated using the output of FileDateTime. However, whenever I query this table using the file name and...

Thanks for the replies everyone. Let me answer individually below: Ridders: No, I haven't tried linking the spreadsheet then importing to a buffer table, and then running an update. The problem I have is that the records in the spreadsheet not only change but new ones are added and existing...

I'm having an issue whereby I set-up and configure an import of an Excel spreadsheet into Access 2016. I carefully configure which fields I want to have as an index and which fields should be skipped, and then opt to save the import for future use. The import on its first run is successful and...