Unanswered: Macro to Import and format Data from ACCESS
I am pretty familiar with MACROS in Excel but never had to deal with ACCESS. Here is what i am trying to do , I have an ACCEss database that has multiple queries I am writng a macro that runs all 16 queries and runs the FINAL query that gives me an output table. Now I want to wirte Excel macro to Import that table and do data parsing and formatting on it ..I need help with the Import part only. Keep in mind the Data changes every week but file names remain the same.