Search results

Didn't see your reply until just now. I have been refactoring for the last 3 hours to incorporate your thinking. Much more complex code but works brilliantly and feels really solid. Now i just dump the raw downloaded spreadsheet into a known source folder and the code gets all the bits of data...

Thanks GaP42 The reason for not using standard formats like QIF is that the relevant banks are of the swiss variety and offer very limited and non-structure exports only in csv/xlsx. It is not me that wants to incorporate headers, but the bank which includes rows at the top and bottom which are...

Thanks for your comment. I would respond: 1. The idea is to add new rows to the same spreadsheet rather than keep separate spreadsheets 2. The flag would mean it is not relevant if the same spreadsheet is 'imported' as only records which have the imported flag set to false would be imported

Very much want to make it easy for readers to assist so I ahve now asked ChatGPT to summarise my request - here is the output: Request: Importing Microsoft Excel into Microsoft Access with VBA I'm looking for assistance with importing bank statements in CSV or XLSX format into Microsoft...

Hi - I am new here. I am a reasonably experienced Access developer and am close to the MVP stage of developing an investment tracking application with double-entry bookkeeping. The last module/functionality for this version will be handling bank statements. I have not worked with Excel to Access...