I had a similar problem getting data from nightclubs, many of the entries having been written at 2am whilst "merry". I converted the Excel to a CSV then wrote a routine which read in the first line and parsed it to extract the column headers. It used a translation table to create a cursor with the data in the same order as the supplied data but with my fieldnames, eg forename for first name, forenames, Christian name, etc. The data was imported as a CSV into the cursor so that the first line was dropped. The cursor was then scanned and each record scattered then inserted into an empty Import table in my format. The import table then went through my standard import and validation process to go into the main database.
It won't help with hidden columns but could some automation help? John Weller 01380 723235 07976 393631 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
