Excellent idea!
I went ahead and ran a test to see whether if I linked an Excel spreadsheet into Access, and modified the data in Access, the spreadsheet would be changed, and indeed it was, which is good...
I also went ahead and created an Excel macro that loads
any SE4 data file into a spreadsheet, assuming that the spreadsheet has appropriate column headings (what would be the fields of the database - "Long Name", "Short Name", "Tonnage", etc.) for the data file being loaded. It works on CompEnhancement.txt quite nicely!
Now to write the export macro, and create all the worksheets to store the data for all the various SE4 files...
Then, once that self-contained modding tool is complete, I can create an Access database linked to the spreadsheet for those of us who have Access as well as Excel - then we can REALLY rock!
Thanks for the idea of the spreadsheet/database link!
I wouldn't have thought of using BOTH!
Edit: You use Access for "general notes" on SE4? How?
Like notes on empires you encounter, so you can easily search for what you need?
[ December 08, 2002, 03:21: Message edited by: Ed Kolis ]