Oracle & MS Access

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

David
Mon Jul 28 09:42:58 CDT 2003


"Peter" <peterantonis@hotmail.com> wrote in message
news:2dae01c354dd$5810fdc0$a001280a@phx.gbl...
> 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

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