Apologies if I go against any procedures or policies here as this is my first post.
I am trying to import several sheets of data from an Access database into several sheets in Excel. I can do this manually with no problem (going to DATA Tab, slecting the "From Access" icon and going through the steps), so I tried recording a macro while manually going through the steps. See below for code. Now if I run the code, I get the following error "Run-time error '1004': Application-defined or object-defined error.