I have extracted budget data from excel using cross table and i would want to append to the fact table.
CrossTable(Month, Budget )
You have to load it first and then concatenate (because it is a crossatble)
Precsely what i did, I load it initially and created a loop and now appended it.Perhaps you should please write the syntax.
if your crosstable is for example "TableA" and previous tables are "TablesX"
you have to
load * resident TableA;
drop tables TableA, TablesX;
Retrieving data ...