Oracle & MS Access

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

Hello,

I'm brand new to programming in VB.NET and for my first
project I need to do the following:

Connect to an Oracle database (till now no problem with
ODBC) get a table and put it in a MS Access (2000)
database.

Till now I succeed in getting the table and putting it in
a datagrid to show the result, I also can create an .mdb
file but I don't succeed to put my table (dataset, or data
table) into the Access application.

That's one problem, the second is that normally this table
is an historical table with several records for one person
but with only a FROM field an not a TILL field, so it
would be preferable that I immediately can add a field to
it (TILL) that represents the day -1 from the next record
as long as it is the same person (with first a sort on
field personnr and from), the last record of that
person must got the actual date as the TILL date (I
managed this pure in Excel, but not in Access nor in
VB.NET, but like I said I'm very very new in VB).

I hope that someone can help me and I thank you all in
advance

Peter
 
Peter said:
Hello,

I'm brand new to programming in VB.NET and for my first
project I need to do the following:

Connect to an Oracle database (till now no problem with
ODBC) get a table and put it in a MS Access (2000)
database.

Till now I succeed in getting the table and putting it in
a datagrid to show the result, I also can create an .mdb
file but I don't succeed to put my table (dataset, or data
table) into the Access application.

That's one problem, the second is that normally this table
is an historical table with several records for one person
but with only a FROM field an not a TILL field, so it
would be preferable that I immediately can add a field to
it (TILL) that represents the day -1 from the next record
as long as it is the same person (with first a sort on
field personnr and from), the last record of that
person must got the actual date as the TILL date (I
managed this pure in Excel, but not in Access nor in
VB.NET, but like I said I'm very very new in VB).

I hope that someone can help me and I thank you all in
advance
Click to expand...

First you must create a table in access. Access supports the "CREATE TABLE"
statement, look in the Access help, or the Microsoft Jet reference on MSDN
for detaile.

For the second part, if you are using 8i+, Oracle Analytic functions will
allow you to very simply add the TILL column in your query. Or you can just
sort the DataTable in memory, and add the TILL yourself.

David
 
Back
Top