community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

How can we loop through and extract multiple tables and load into a different database?

Thanks for the info! I actually just built one of these to convert all tables and existing queries to yxdb format. If you want to get all the table and query names from an accdb file quickly you can use the following SQL in a new query:

 

SELECT MSysObjects.Name AS table_name
FROM MSysObjects
WHERE LvProp IS NOT NULL AND Name <> "MSysDb" AND Name <>"SummaryInfo";
Labels