Hi, I have a new project that consist of transfering a JD Edwards
Database to an MS Access database. I am just starting to learn how
those 2 databases works. What is the general idea behind this??
Outputing the data to a text file and read it? I just need the basic
concept please.
Thank you very much!
Marc-Andre 3 4505
Marc,
You can do it two ways:
1. Link to the text file
2. Import the text file
Both are done through File-Get External Data
When you link, Access treats the text file as an Access table and any changes
you make to the data through the link get changed in the text file.
When you import, Access creates an Access table of the data in the text file;
there is np connection between the table and the text file. When you make
changes to the data in the table, it ends there; the data in the text file
remains unchanged.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications re******@pcdata sheet.com www.pcdatasheet.com
"Marc Nadeau" <mn*******@hotm ail.com> wrote in message
news:Xn******** *************** **********@216. 196.105.130... Hi, I have a new project that consist of transfering a JD Edwards Database to an MS Access database. I am just starting to learn how those 2 databases works. What is the general idea behind this?? Outputing the data to a text file and read it? I just need the basic concept please.
Thank you very much! Marc-Andre
"PC Datasheet" <no****@nospam. spam> wrote in
news:vE******** ***********@new sread3.news.atl .earthlink.net: Thank you for your answer,
So I have to export all the tables individually and import them one
after the other in Access. Then i have to observe the relationship,
primary key... used in the original database (JD Edwards) and create/use
the same one in Access? (the goal is to transfer the database from JD
Edwards to Access) Anything else I should know?
Thank You very much
Marc
Marc, You can do it two ways: 1. Link to the text file 2. Import the text file Both are done through File-Get External Data
When you link, Access treats the text file as an Access table and any changes you make to the data through the link get changed in the text file.
When you import, Access creates an Access table of the data in the text file; there is np connection between the table and the text file. When you make changes to the data in the table, it ends there; the data in the text file remains unchanged.
-- PC Datasheet Your Resource For Help With Access, Excel And Word Applications re******@pcdata sheet.com www.pcdatasheet.com
"Marc Nadeau" <mn*******@hotm ail.com> wrote in message news:Xn******** *************** **********@216. 196.105.130... Hi, I have a new project that consist of transfering a JD Edwards Database to an MS Access database. I am just starting to learn how those 2 databases works. What is the general idea behind this?? Outputing the data to a text file and read it? I just need the basic concept please.
Thank you very much! Marc-Andre
Check if JD Edwards can batch export data so you don't have to do each table
individually. Also when you export, name the text files in some logical manner
such as Text1, Text2, Text3, etc. Before importing indivually, look at the
TransferText function in the Access Help file. With a structured naming system
of the text files, you could easily write a routine to automatically import the
text files to Access.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications re******@pcdata sheet.com www.pcdatasheet.com
"Marc Nadeau" <mn*******@hotm ail.com> wrote in message
news:Xn******** *************** **********@216. 196.105.130... "PC Datasheet" <no****@nospam. spam> wrote in news:vE******** ***********@new sread3.news.atl .earthlink.net:
Thank you for your answer,
So I have to export all the tables individually and import them one after the other in Access. Then i have to observe the relationship, primary key... used in the original database (JD Edwards) and create/use the same one in Access? (the goal is to transfer the database from JD Edwards to Access) Anything else I should know?
Thank You very much Marc
Marc, You can do it two ways: 1. Link to the text file 2. Import the text file Both are done through File-Get External Data
When you link, Access treats the text file as an Access table and any changes you make to the data through the link get changed in the text file.
When you import, Access creates an Access table of the data in the text file; there is np connection between the table and the text file. When you make changes to the data in the table, it ends there; the data in the text file remains unchanged.
-- PC Datasheet Your Resource For Help With Access, Excel And Word Applications re******@pcdata sheet.com www.pcdatasheet.com
"Marc Nadeau" <mn*******@hotm ail.com> wrote in message news:Xn******** *************** **********@216. 196.105.130... Hi, I have a new project that consist of transfering a JD Edwards Database to an MS Access database. I am just starting to learn how those 2 databases works. What is the general idea behind this?? Outputing the data to a text file and read it? I just need the basic concept please.
Thank you very much! Marc-Andre
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Steve McDonald |
last post by:
Can anyone help me??! What is the best way to import data from One World
into SQL Server? If it's possible to use DTS then should I use the OLEDB
connection object?
Many thanks,
Steve
|
by: Jerome |
last post by:
Hi, I'm a bit confused ... when would I rather write an database
application using MS Access and Visual Basic and when (and why) would I
rather write it using Visual Studio .Net?
Is it as easy in Visual Studio to create reports and labels as it's in
Access?`
The advantage of VS.net is that not every user needs Access, right? And
that would eliminate the Access version problem as well I guess.
|
by: bill |
last post by:
I am trying to convince a client that dotNet is preferable to an Access
project (ADP/ADE).
This client currently has a large, pure Access MDB solution with 30+ users,
which needs to be upgraded.
I believe a dotNet solution is better, but I'm trying to be as convincing as
possible -- and maybe I'm wrong!
I would appreciate any input or references which could help me.
|
by: Dave |
last post by:
Hello NG,
Regarding access-declarations and member using-declarations as used to
change the access level of an inherited base member...
Two things need to be considered when determining an inherited base member's
access level in the derived class: its access level in the base class and
the type of inheritance (public, protected, or private). After this
determination is made, the following possibilities exist for manually
changing the...
|
by: Igor V. Rafienko |
last post by:
Hi,
I am trying to understand how cElementTree's clear works: I have a
(relatively) large XML file, that I do not wish to load into memory.
So, naturally, I tried something like this:
from cElementTree import iterparse
for event, elem in iterparse("data.xml"):
if elem.tag == "schnappi":
| |
by: Jon |
last post by:
There's an interesting interview with Gary Edwards, one of the
leaders of the team developing the Open Document Format (used in
StarOffice8, OpenOffice2, etc.) See:
http://madpenguin.org/cms/html/62/5304.html
One comment Gary made was particularly bold:
"...OpenDocument is now before the ISO (International Standards
Organization) board for ratification. From there, there is no doubt
|
by: T-Bird |
last post by:
Database skills in SQL Server, DB2 UDB and DB/400 are essential.
Salary Up to 90K DOE
Location: Denver, CO. Phoenix, AZ. or Columbia, SC.
Relo : Will consider for the right person
Responsibilities
Responsible for J.D. Edwards OneWorld Xe, ERP8, and ERP9 technical
support. Will provide consultative services to internal sales and
solution engineers during the sales cycle, as well as Agilera clients
|
by: Marc Nadeau |
last post by:
Hi, I have a project that consists to transfer a database from JD Edwards
to MS Access. I am just starting to learn those programs and i would like
to know the basic concepts.
Here is what I think:
I have to export all the tables individually from JD Edwards to a text file
and import them one after the other in Access. Then i have to observe the
relationship between the tables and the primary keys used in the original
database (JD...
|
by: watches0898 |
last post by:
Edwards Garments Company is one popular industry specific designer
specializing in work wear that ranges from chef coats to chef hats to
separates to housecleaning uniforms. Edwards Garments Company has a
reputation for providing a high quality, affordable solution to the
professional man's or woman's wardrobe. Often, white is the color
given most focus, but a variety of colors are offered to wet your
appetite, so to speak.
...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |