Creating a "create table" script for an Oracle DB

[Guest]

Hi

I need to give to an Oracle DBA an SQl script to create in his DB a table
with the same structure as one of my Access DB table, the content of which I
will insert afterwards in a daily processing in that table in the Oracle DB.

I can't find find any way in Access to "export" the table structure in the
form of a standard SQL script that can be used by the Oracle guy. I'm
surprised, because that possibility is existing in SQLServer. Am I blind, or
how do I do it ?

Thanks for help
Balex

 

[Roger Carlson]

It is not built into Access, but there are third-party products that do it.
Like this shareware product:
http://www.freedownloadscenter.com/Utilities/Misc__Utilities/Access_2_SQL.html


--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L