When I first started using Blitz, and I want too aware of how it worked etc back then, I had the database for a RPG (i.e all the spell data, weapon/item data, skill information etc etc) all in M$ Access tables. I asked on here if there was a way to import the data at all, but unfortunately not. So there was me, not wanting to write it all out again, I had the amazing brainstorm:
Export tables to Excel format.
By using Extra Columns in Excel spreadsheet, and the COncatenate function, I could change something like:
(please excuse bad format)
__________________________
|WEAPON|COST|WEIGHT|MAGIC|
|______|____|______|_____|
|SWORD_|100_|50____|____1|
|AXE___|200_|75____|____1|
to the following:
DATA "SWORD",100,50,1
This was a great way to then get something that could be Copy & Paste-ed into Blitz no problem!
:)
Export tables to Excel format.
By using Extra Columns in Excel spreadsheet, and the COncatenate function, I could change something like:
(please excuse bad format)
__________________________
|WEAPON|COST|WEIGHT|MAGIC|
|______|____|______|_____|
|SWORD_|100_|50____|____1|
|AXE___|200_|75____|____1|
to the following:
DATA "SWORD",100,50,1
This was a great way to then get something that could be Copy & Paste-ed into Blitz no problem!
:)