Forum Discussion
Best practice for importing data from multiple databases
Hello, your understanding is bang on. Thats the way to do it:
1. Import the tables.
2. For each Table add the custom column: Add Column >> Custom >> [NewColumnName]"Region Name" Custom column Formula ="Name you are needing"
3. Home >> Append Queries >> Append queries as new >> Three or more tables. Select all the tables you want to add to the append, click add and click ok.
Hello, your understanding is bang on. Thats the way to do it:
1. Import the tables.
2. For each Table add the custom column: Add Column >> Custom >> [NewColumnName]"Region Name" Custom column Formula ="Name you are needing"
3. Home >> Append Queries >> Append queries as new >> Three or more tables. Select all the tables you want to add to the append, click add and click ok.