LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how can i convert digists in to characters in a spread sheet Raja Aurongzeb Excel Worksheet Functions 1 December 5th 07 08:14 AM
convert excel spread sheet into txt.cvs document D.B. Excel Discussion (Misc queries) 1 September 6th 07 05:15 PM
Convert info from database to spread sheet Scared CO-OP :) Excel Discussion (Misc queries) 1 October 13th 06 11:07 PM
convert spread sheet to pdf Tara Excel Discussion (Misc queries) 1 March 28th 06 08:48 AM
HOW TO CONVERT EUROS TO SWISS FRANCS IN A EXCEL SPREAD SHEET Veronica Excel Worksheet Functions 2 December 14th 04 05:01 PM


All times are GMT +1. The time now is 05:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"