Darryl Collins
darryl at whittleconsulting.com.au
Sun May 20 21:05:45 CDT 2012
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