Objective = import SQL Server Compact 3.5 database data in excel in real time(data in excel should update as new data are stored in database). the database file extension is SDF.
* Ability to open different database per excelsheet.
* Ability to limit # records to pull from database.
* Ability to Fix the Last row and update the new data from bottom up.
* Ability to select perticular table data to pull from database.
* ability to save this settings in excel file so when opened again it will refresh automatically.
* Database is located in my document folder.
Will provide sample database file.