Recent content by gingermatti

Thanks Dennisk. Not quite sure what that means! I'm no mug but is that something [relatively] easily achieved? In other words, I'm not a programmer but I came across the following code from a nice man: Public Sub importexcelfiles() strpath = "C:\My Documents\myexcelfiles\" strfile =...

I have 100 or so 2-sheet excel workbooks. I need to import them all into an access table for analysis. They are all exactly the same format/layout etc but obviously have different data in them (they are customer satisfaction surveys). I only want to export 1 out of the 2 sheets on each workbook...