[AccessD] Code to auto-load an ORACLE schema

I have no access to the original database . I was working off some excel
data.

Thx
On May 20, 2012 10:07 PM, "Darryl Collins" <darryl at whittleconsulting.com.au>
wrote:

> It looks like you have this underway Bill, even so, don't discount the
> MySQL / Toad solution suggested here by Jim.  Given that Oracle now own
> MySQL it should behave rather well with Oracle data sources.  MySQL
> integrates fine with MS Access as well (at least using A2010) - I have used
> it a few times now to do special jobs and other data mashing stuff.  Given
> that it is all free as well.  If you do download MySQL, then I suggest you
> get both Toad and MySQL Workbench as GUI's into MySQL.
>
> Cheers
> Darryl.
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:
> accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
> Sent: Saturday, 19 May 2012 8:18 AM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Code to auto-load an ORACLE schema
>
> Have you looked at Toad? Many moons ago, I used Toad to export out of
> Oracle into DBase format and then imported it into Access. It was A2K as I
> remember.
>
> I also believe that there is a option in MySQL that will allow you to
> export out of Oracle and I believe you can import from MySQL into Access
> but have not checked it out. The new Oracle has some interesting feature as
> well.
>
> There are some good third-party software products that can perform exports
> and imports... The name escapes me but the price was somewhere around $100
> at module.
>
> Jim
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Benson,
> William (GE Global Research, consultant)
> Sent: Friday, May 18, 2012 10:13 AM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Code to auto-load an ORACLE schema
>
> I have some Oracle table information that looks like below. I would like
> to have some tables in my Access database get auto-created based on this
> kind of information.
>
> Does someone have a routine to do this kind of thing?
>
> My bigger issues are the data sizes, and the special NUMBER (p,s) - which
> I don't think Access will handle except perhaps through validation rules,
> which I don't have the skill at this time to write.
>
> I know this is just a sample of the data types I might need to be
> concerned with.
>
>
> Table Name      Field Name              Type & Size             My Comments
> CUSTOMER        ADDRESS_LINE1           VARCHAR2(240)   is the default
> Subtype CHAR or BYTE
> CUSTOMER        CREATED_DT              DATE
> EMPLOYEE        LAST_LOGIN_DT           TIMESTAMP(6)
> EQUIPMENT       CAPACITY_FACTOR         NUMBER(38)
> EQUIPMENT       COMMENTS                       VARCHAR2(4000)
> would have to treat as memo
> EQUIPMENT       UNIT_NUMBER                VARCHAR2(30 CHAR)      is the
> default CHAR or BYTE
> EQUIPMENT       INTRV_BIS_C                     NUMBER(5,2)             How
> to handle this - validation rule?
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>