I am sure there is an easy way to do this. I have an excel spreadsheet that gets dropped each Monday.
I need to automate this file to import into access and dump into our SQL tables. Right now we have to manually delete the first 2 rows (Header and a blank line). The file names are at row 3 and we only need columns A:L. What code can I write that is the easiest way to do this?
I have a screen shot of the actual file after I opened it in excel. MDD-Image.PNG
Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat. The purpose of this eBook is to educate the reader about ransomware attacks.