1 of 1 people found this helpful
Yes. You can create a new datasource connection within your workbook that points at the database. Then you can go up to the data menu and choose replace datasource which substitute out the new one for the old one. Granted the new one has to have the same fields / calcs / metadata.
it's necessary to have the same fields / calc / metadata ?
The data base (sql) it's not in the same format. they are not build on the same model, the model is much larger than the final exel file that will serve as a table.
Tables (columns and and lines) are not the same layout. I am given an exel file in which a person has gone to search for information that is scattered in a database.
do you have an idea ?
Yes, it's typical that the database will be much more expansive than what exists in the Excel file, however you should be able to join the tables together in SQL, create the needed calcs, and hide the fields that are not pertinent and don't belong.
you think you have to redo the template from the beginning to link the SQL database to the new template I created or I can modify the one I created with the exel databases. Do you have an idea of a tutorial to start my research? thank you