View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael Lui Michael Lui is offline
external usenet poster
 
Posts: 1
Default 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.