Hello Chandru,
I dont have access in my workstation to test or develop. So I tryed to do as
it is in my mind with an excel
Just to explain, Access and Excel they run VBA Code with macros, you can
find examples and tutorials at www
You will need a small program to load your data, the sub will be called from
the button, this might be very similar to the one I wrote:
I´m sorry for the bugs and sintax errors, and I hope it helps you.
'Conect to database
Sub conecta()
Dim conexao As String
Dim userName As String
Dim passWord As String
Dim userPass As String
On Error GoTo conn_sgi_error
'Setup
conexao = DB_TRAVEL 'Database schema name
userName = XPTO
passWord = XPTO
userPass = userName & "/" & passWord
'open Serv Oracle
Set OraSession = CreateObject("OracleInProcServer.XOraSession")
Set OraDatabase = OraSession.OpenDatabase(conexao, userPass, 0&)
MsgBox "Oracle connection OK!"
'clean
GoTo conn_sgi_fim
conn_sgi_error:
MsgBox "Oracle Connexion ERROR! Contact DBA:" & Err & ":" & Error
'Resume conn_sgi_fim
End
conn_sgi_fim:
On Error GoTo 0
End Sub
----------------------------------------------------------------------------------------------------------------------------------------------------------------
Sub desconecta()
On Error Resume Next
Set OraSession = Nothing
Set OraDatabase = Nothing
On Error GoTo 0
End Sub
------------------------------------------------------------------------------------------------------------------------------------------------------------------
Sub load_data()
conecta
Dim sqlwhere As Boolean
sql = ""
sql = sql & "BEGIN ALTER SESSION SET NLS_DATE_FORMAT = 'DD/MM/YYYY';
END;"
OraDatabase.DbExecuteSQL("alter session set NLS_DATE_FORMAT =
'DD/MM/YYYY'")
sql = ""
sql = sql & " SELECT CITY_NAME, STATE_NAME FROM STATES_TABLE WHERE
COUNTRY_NAME = BRAZIL '
Set mDynaset = OraDatabase.CreateDynaset(sql, 0&)
While Not mDynaset.EOF
' INSERT INTO ACCESS '
mDynaset.DbMoveNext
Wend
mDynaset.Close
desconecta
End Sub
2010/11/3 Rahul <rpchandraseka...@gmail.com>
> Hi All,
> Thanks
> It isn't one time process every month we are upload the data to oracle
> database.
> My requirement is every month I got one access file from share market
> which file I upload the database.
> Right now I generate the text file from access and upload to back end
> procedure.
> But I need to upload the data from Front end.
> For example: my from design is only two steps.
> 1.Browse the access file from cd drive.
> 2.Push Button (This push button when we click the access data moving
> to oracle table.
> Access 2007
> Oracle 10g
> Forms 6i
>
> Thanks
> Chandru
>
>
>
>
> On Nov 3, 9:10 pm, Richard Pascual <richg...@gmail.com> wrote:
> > Hi,
> > I see you have two different tasks at hand:
> >
> > 1) import data and database structures from Access to Oracle
> > 2) convert Access forms to Oracle Forms 6i
> >
> > You may want to look into Oracle Application Express (APEX); it is a
> > web-based version of the Forms 6i product AND it has a migration tool for
> > converting entire Access databases (forms and underlying data structures)
> in
> > a simple, step by step process.
> >
> > APEX is a free add-on of PL/SQL packages and procedures which works with
> > Oracle 10g. If you use Oracle 11g, it comes built into the standard
> install
> > of the product. APEX is not an additional piece of software but a
> collection
> > of built-in PL/SQL packages used to augment your database and to allow it
> to
> > function as a web-based app server. The entire APEX framework is
> > downloadable athttp://apex.oracle.com;there is a lot of documentation
> and
> > how-to instructions with examples there as well.
> >
> > Otherwise, the only way I see a conversion of Access forms to Oracle 6i
> is
> > to manually reproduce functionality and layout screen by screen.
> >
> > Rich
> >
> >
> >
> > On Tue, Nov 2, 2010 at 2:41 AM, Rahul <rpchandraseka...@gmail.com>
> wrote:
> > > Hi All,
> > > I have one access databse file(2007).I need to insert the data to
> > > orcle 10g my application front end is D2k(forms6i).
> > > Give me some example to insert data through form 6i.
> > > help me
> > > Chandru
> >
> > > --
> > > You received this message because you are subscribed to the Google
> > > Groups "Oracle PL/SQL" group.
> > > To post to this group, send email to Oracle-PLSQL@googlegroups.com
> > > To unsubscribe from this group, send email to
> > > oracle-plsql-unsubscr...@googlegroups.com
> > > For more options, visit this group at
> > >http://groups.google.com/group/Oracle-PLSQL?hl=en
>
> --
> You received this message because you are subscribed to the Google
> Groups "Oracle PL/SQL" group.
> To post to this group, send email to Oracle-PLSQL@googlegroups.com
> To unsubscribe from this group, send email to
> oracle-plsql-unsubscr...@googlegroups.com
> For more options, visit this group at
> http://groups.google.com/group/Oracle-PLSQL?hl=en
>
--
Leandro Marçal - Zidane
http://leandromarcal.blogspot.com
CEL.: 8356-4670 / NEXTEL.: 21881*104
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
