Hello! I am new to the forum and to excel.
We have a huge excel database that we would like to transfer to an SQL Server. The database consists of PowerPivot tables and some regular ones that apparently come from tab delimited text files. The problem is that to mimic the PowerPivot relationships in the SQL database we need the business logic behind the pivot tables.
Where could this business logic be? Can i find it somewhere or can I, say, convert the pivot table to excel formulas so that i can see where the different values come from? I am feeling somewhat comfortable with Visual Basic already so programming ideas are welcome as well.
We have a huge excel database that we would like to transfer to an SQL Server. The database consists of PowerPivot tables and some regular ones that apparently come from tab delimited text files. The problem is that to mimic the PowerPivot relationships in the SQL database we need the business logic behind the pivot tables.
Where could this business logic be? Can i find it somewhere or can I, say, convert the pivot table to excel formulas so that i can see where the different values come from? I am feeling somewhat comfortable with Visual Basic already so programming ideas are welcome as well.
