ORACALIZE_TABLE_FIELDS.zip |
Post Reply |
Author | |
Randy Farthing
Contributor Joined: 24 Jun 2008 Status: Offline Points: 1 |
Post Options
Thanks(0)
Posted: 10 Jul 2008 at 5:36am |
This app is designed to change field names for tables destined to move to Oracle. A button on the main form will capitalize field names, substitute "_"s in place of spaces, optionally place a "_" in front of upper case letters imbedded within the field name, the turn the whole field name to upper case. It will change format for all fields, but reports any fields longer than the 30 char Oracle limit. This may not be perfect, but in aN Oracle conversion, this did save me more time than it took to create.
This is written in Access 97. Hasn't been tested in any other version. Download Access 97: uploads/11/ORACALIZE_TABLE_FIELDS.zip |
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |