Hello,
I want to import data from MS Access into Power Query using the original SQL from Access. But I get errors on the IFFS and other parts. Is there a way to use the native Access SQL in Powerquery?
Also is there a way to run a macro in Access before going to the query? The last part isn't extremely important I can do that with a macro in Excel .
Bookmarks