Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > Access-L Developer's Libraries > Farthing, Randy
  New Posts New Posts RSS Feed - ORACALIZE_TABLE_FIELDS.zip
  FAQ FAQ  Forum Search   Events   Register Register  Login Login


Please consider donating $1 per sample downloaded, (find out why here)

ORACALIZE_TABLE_FIELDS.zip

 Post Reply Post Reply
Author
Message
Randy Farthing View Drop Down
Contributor
Contributor


Joined: 24 Jun 2008
Status: Offline
Points: 1
Post Options Post Options   Thanks (0) Thanks(0)   Quote Randy Farthing Quote  Post ReplyReply Direct Link To This Post Topic: ORACALIZE_TABLE_FIELDS.zip
    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

Back to Top
Sponsored Links


Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down