Hello,
I'm looking to see the best way to go about the following:
There's a .xlsx spreadsheet outputted to a network folder each month. The spreadsheet always has 3 worksheets, one of which is subject to change in terms of the data within. For example, there could be some months in which that particular worksheet has zero records on it - but would still have a header row regardless.
If the worksheet doesn't have any actual records below the header row, there would be no need to import it into the Access DB.
I'm able to program the actual import process through VBA, but not sure how to check to see if there are any records prior to importing - would this require the use of the Microsoft Excel Object Library/References?