I have inherited a relational database. I need to automate the creation of a flat file from this database in excel format for automated input into another database.
The problem is, I can't seem to figure out how to create a query that will combine the relational data into a flat file format...