derivative data from the ACCESS

[thread]

Hi all,
i need to develop a code that will make derivative from other ACCESS
data code,
what is the easiest way to pull out the data in this way?

 

[Van T. Dinh]

(A wild wild guess) Are you talking about pulling data from other Access
databases to a new database?

If that's the case, you can create a new database file then link or import
data from other databases.

If that's not what you asked, you will need to explain a quite a bit more
using database terminology as I don't think too many people wuold be able to
work out what you needed from your post.

 

[thread]

hi Dihn
thanks this is what i meant,
just to pull data from one ACCESS to another without the option of full
access to the file we are taking data from(just relevant of course)
Van T. Dinh ëúá:

 

[Van T. Dinh]

Still not sure what you meant but if you don't have access to the source
data, you can't get to the data!

If you have access to the data in the other Access database then just create
Linked Tables in your database to point to the Tables in the other data and
then you can use the data (directly through a Select Query) or use a
Make-Table Query (with selection criteria) to create a new Table in your
database with only the required data.

--
HTH
Van T. Dinh
MVP (Access)



hi Dihn
thanks this is what i meant,
just to pull data from one ACCESS to another without the option of full
access to the file we are taking data from(just relevant of course)

 

[thread]

Hi Dinh,
let me ask this question to the point
i need to build some kind of code for derivative data from a SAP
system,is it posible or its too complicated or there is very easy
solution for this?

Van T. Dinh ëúá:

 

[Van T. Dinh]

I don't know SAP so if you want to build code to derived data in SAP and
then save the derived data in an Access (JET, actually) database, you will
need to ask somewhere else.

If you want to build code (which may not be necessary as it is often more
efficient to use Access Make-Table / Update queries to manipulate the data)
in Access to manipulate the data and then save the data in the database,
then you need ***to make the (raw) data available in Access first***. This
can be done in a number of ways depending on whether ODBC / OLEDB drivers
are available for SAP:

* ODBC-linked Tables then manipulate the data and save the derived data into
other Access/JET Tables.
* Import data into (temporary) Tables then manipulate the data as above ...
* Use VBA + OLEDB driver to access the SAP data then same as above ...

You will need to check the availability of ODBC driver / OLEDB driver for
SAP databases ... before you can proceed further.

Whether the process is complicated or not, I guess it depends on what kind
of manipulation you need and your knowledge of Access and VBA ... but in
general, if the source data is consistently structured (and I would say that
SAP data is), data manipulation is possible ...

--
HTH
Van T. Dinh
MVP (Access)



Hi Dinh,
let me ask this question to the point
i need to build some kind of code for derivative data from a SAP
system,is it posible or its too complicated or there is very easy
solution for this?