Hi,
I have more than 60 tables to be created in access. I have the "create table" scripts generated out of oracle.
Please let me know how to run these scripts and if they require any modifications to be done.
Thanks
BMG
I've never used Oracle before so I cannot say this with certainty but I believe the answer is yes it is possible. Though the syntax maybe slightly different and the scripts may require a little tweaking. Running DDL create table statements are done through the query editor. Create a new database. Create new query and close the select table popup. Switch the view to SQL and this is where you can add your create table statement.
Here's the syntax: -
CREATE [TEMPORARY] TABLE table (field1 type [(size)] [NOT NULL] [WITH COMPRESSION | WITH COMP] [index1] [, field2 type [(size)] [NOT NULL] [index2] [, ...]] [, CONSTRAINT multifieldindex [, ...]])
-
The CREATE TABLE statement has these parts:
Part Description table The name of the table to be created. field1, field2 The name of field or fields to be created in the new table. You must create at least one field. type The data type of field in the new table. size The field size in characters (Text and Binary fields only). index1, index2 A CONSTRAINT clause defining a single-field index. multifieldindex A CONSTRAINT clause defining a multiple-field index.
3 7264
I've never used Oracle before so I cannot say this with certainty but I believe the answer is yes it is possible. Though the syntax maybe slightly different and the scripts may require a little tweaking. Running DDL create table statements are done through the query editor. Create a new database. Create new query and close the select table popup. Switch the view to SQL and this is where you can add your create table statement.
Here's the syntax: -
CREATE [TEMPORARY] TABLE table (field1 type [(size)] [NOT NULL] [WITH COMPRESSION | WITH COMP] [index1] [, field2 type [(size)] [NOT NULL] [index2] [, ...]] [, CONSTRAINT multifieldindex [, ...]])
-
The CREATE TABLE statement has these parts:
Part Description table The name of the table to be created. field1, field2 The name of field or fields to be created in the new table. You must create at least one field. type The data type of field in the new table. size The field size in characters (Text and Binary fields only). index1, index2 A CONSTRAINT clause defining a single-field index. multifieldindex A CONSTRAINT clause defining a multiple-field index.
- Sub ImportDDL()
-
-
Dim File As Integer
-
Dim Data As String
-
Dim Records As Long
-
Dim SQLstring As String
-
-
File = FreeFile()
-
Open "C:\temp\DDL_MSAccess_2021-05-10.sql" For Input As #File
-
-
SQLstring = ""
-
While Not EOF(File)
-
Line Input #File, Data
-
SQLstring = SQLstring & Data
-
If InStr(Data, ";") > 0 Then
-
Debug.Print (SQLstring)
-
DoCmd.RunSQL (SQLstring)
-
SQLstring = ""
-
Records = Records + 1
-
End If
-
Wend
-
Close #File
-
-
Debug.Print (Records)
-
-
End Sub
NeoPa 32,556
Expert Mod 16PB
That's clean & tidy code Dave, but I'm not sure it deals with the fundamental issue of the scripts being in an Oracle format rather than Access. There are many points of difference between the two.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Rolfe |
last post by:
Hi, I struggled, and got mod_python running on Apache/Win2k. Follow
these instructions verbatim and you shouldn't have any trouble. These
instructions are based on...
|
by: Peter Otten |
last post by:
Is there a way to limit both width and height of a canvas text item?
My current workaround seems clumsy:
import Tkinter as tk
root = tk.Tk()
canvas = tk.Canvas(root, width=400, height=200,...
|
by: Patrick |
last post by:
Hi,
The company's database has multiple schema.
If I want to modify a stored procedure, which is saved as a script
(something like abc.sql), I opened that script in Query Analyser, made
the...
|
by: Sravani |
last post by:
Hi,
I am setting up a new server for an already running website. The problem is
the person before me ran ASP scripts on .html extension pages (The old
machine is a windows 2000 server with IIS...
|
by: Nick Sinclair |
last post by:
Hi all,
I'm new to C.
I have successfully written a small C program that acts as a "wrapper"
around cgi scripts. These scripts perform admin tasks such as backing up
etc. Obviously, The need...
|
by: edovale |
last post by:
Hi there,
I am trying to create a db on db2 and when running the scripts, which
have been successfully ran before, I get the following error:
DB21034E The command was processed as an SQL...
|
by: Dave Hughes |
last post by:
Just noticed something rather annoying after upgrading my test box (a
Linux server running DB2 UDB v8 for LUW) to fixpak 11 (for reference it
was previously on fixpak 7).
In the past I've relied...
|
by: Ishpeck |
last post by:
I'm using Python to automate testing software for my company. I
wanted the computers in my testing lab to automatically fetch the
latest version of the python scripts from a CVS repository and...
|
by: Mark |
last post by:
Hi, I'm new to python and looking for a better idiom to use for the
manner I have been organising my python scripts. I've googled all over
the place about this but found absolutely nothing.
I'm...
|
by: V S Rawat |
last post by:
(bringing the discussion here for php.general)
I am on xpsp3, wampserver 2.0, having apache 2.2.8, php 5.2.6, MySQL
5.0.51b. http://localhost/ is E:\wamp\www\
I have put the first php script...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |