![]() |
Convert an Excel Spread Sheet to a Relationship Database
We have an Excel spread sheet that contains macros and links. I was told the macros defined the relationships of cells. The person who created the spread sheet has left the company, and our users are afraid to do anything with the spread sheet because no one really knows all the details in the spread sheet. Also, the data that they have is hitting the Excel maximum limit, so we need to extract out the data and put them into a relational database. Is there a way that we can extract, not just the data, but all the relationships defined in the macros and links, to create any relational database (Access, MS SQL Server, Sybase, Oracle, etc.)? By the way, we are using Excel 2000 (9.07616 SP-3). Thanks.
|
Convert an Excel Spread Sheet to a Relationship Database
Someone is going to have to go through those macros to
determine the relationships, if thats the case. If no one has that ability you will probably require the services of an excel vba consultant, whom can be found on the web. |
All times are GMT +1. The time now is 04:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com