Convert an Excel Spread Sheet to a Relationship Database

G

Guest

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.
 
A

Al

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

convert Excel data to Access 2
Converting Excel SS to a Web Form 1
macros to query a database 9
how can i convert digists in to characters in a spread sheet 1
How to read Excel Spread Sheet in VB 3
Using an Excel Spreadsheet as A Data source for Miscrosoft Query 1
Query from Access Database based on user selected parameters in Excel 2
Excel, Macros, Database 1

Top