I hope I can be forgiven for trawling up a thread from six years ago (before my time on the forum, I should add), but this is something of great interest to me: namely, how to automate (not possible, without some preliminary work in the spreadsheet, in my view), or at least speed-up
the process of importing the ubiquitous .xls spreadsheets into "industry standard" equipment database packages.
For me this is still topical, engaged as I currently am in converting .xls data-sets from biomed friends overseas into .dbf in a specific format. The initial step is easy enough. Add some sensible "field names" at the first row in the spreadsheet, and then use Save As ... to save in .dbf (or whatever) format. Next fire up your favourite database manager (FoxPro et al
) and take it from there.
Those first couple of steps take but a couple of minutes ... but carrying on from there can take days and days, depending upon the quality (and clarity) of the original data, and the level of organization required by the recipient database system.
Some of the posts I have read on this issue (and other, related, ones) seem to make light of this laborious process. Over the years I have done a fair amount of this stuff, and wrote software tools on a "needs must" basis when required, but I still say that there cannot be an easy
way. Unless, of course, I'm missing something here.
non-profit does not exist.
... no comment needed there (except to point out that ECRI used to talk about being a "not for profit organization")!