Greetings

Does anyone know if its possible to extract SQL code for table creation from a Access table or view a table definition in SQL within Access.
I want to move the Access database into Oracle.

Thanks

Andrew

Don't know if it will work , but  have you tried using the upsizing wizard. I know its supposed to be for converting it to an sql server db. I get so far with it on mine and it asks for a dsn maybe if you were to supply an oracle dsn instead it might work. I tried using a sql server dsn on mine but it crashes out with an overflow.

Steve

Just highlight the table and do file-saveas and pick ODBC database as type, and the DNS you have set for your oracle.

If in work enviornment, do it on a test instance, log into Toad, review your primary Keys and indexes - then describe will give your the SQL you can give to the DBA.

Easy peesy just like creating a spreadsheet from access table - Everone say "I like Microsoft"  then spend years clearing up aftwards.

Steve,

With SQL Server, you pull in a database - ie from the SQL manager do an improt from a MS database - comes over sweet as a nut....   Boolean and Memo field types need review hoever.

Thanks for that
It did the job nicely although had a slight problem with booleans so had to change them to numbers.

Thanks again

Andy