Jim Lawrence
accessd at shaw.ca
Fri May 18 17:18:26 CDT 2012
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