Solved

How to import data from DataEase to Access

Posted on 1998-01-21
1
1,426 Views
Last Modified: 2012-06-21
How do I import data from a DOS version of DataEase to a Windows version of Access?
0
Comment
Question by:frooze
1 Comment
 
LVL 5

Accepted Solution

by:
cekman earned 50 total points
ID: 1966240
The following is from a MS Knowledge base articl:
 
1.0 1.1 2.0 7.0 97
 
WINDOWS
 

======================================================================
---------------------------------------------------------------------
The information in this article applies to:
 
 - Microsoft Access versions 1.0, 1.1, 2.0, 7.0, 97
---------------------------------------------------------------------
 
SUMMARY
=======
 
Novice: Requires knowledge of the user interface on single-user computers.
 
Microsoft Access does not import DataEase data files directly, but you can
export DataEase data to a formatted disk file that Microsoft Access can
import. The information in this article applies to DataEase versions 4.2,
4.5, and 4.53. DataEase is a character-based relational database system.
 
To export DataEase data from DataEase, create a DQL report, specify the
Format as export, and set the Print Style to print to a disk file. Select
one of the following export formats to create a file Microsoft Access can
import:
 
   Lotus           (creates a .WKS file)
   Variable Length (creates a delimited ASCII text file)
   Fixed Length    (creates a fixed-width ASCII text file)
 
MORE INFORMATION
================
 
Export Using DataEase
---------------------
 
To create a formatted disk file in DataEase 4.x, create a DQL report using
the following steps. For more detailed information about creating reports,
please refer to the DataEase documentation.
 
1. Define the report specifying the fields you want to include in the
   output.
 
2. Specify the report Format as Export by choosing either Define Format or
   Modify Format under either DQL Advanced Processing or Query by Example -
   Quick Reports.
 
   Select 7. Export under Define Format or Modify Format. You should see
   the following list of the export formats DataEase supports:
 
      * 1. Lotus (wks)
        2. GrafTalk
        3. MultiMate
        4. WordPerfect
        5. Mail-Merge
      * 6. Variable Length
      * 7. Fixed Length
        8. DIF
 
   Choose 1, 2, or 6. Depending on your choice, DataEase may ask you if you
   want to include field names in the exported file.
 
3. Specify the Print Style for the report. Enter the Report Destination as
   option #3 Disk to print to a disk file. Then enter a valid file name in
   the Filename field.
 
Import Using Microsoft Access
-----------------------------
 
1. Start Microsoft Access and open your database.
 
2. On the File menu, click Import.
 
3. In the Data Source box, select the import format that matches the export
   format you chose in DataEase.
 
Choosing Export/Import Format
-----------------------------
 
Here are some things to consider when choosing an export/import format.
 
Microsoft Access can import Lotus (.WKS) files and create a table with
field names if you included the field names when exporting in DataEase.
During the import process, Microsoft Access asks you if the first row
contains field names. Most DataEase data types should convert to
appropriate Microsoft Access field types.
 
If you choose the Variable Length format when exporting, DataEase will ask
you to enter the field separator. Enter a comma (,). Microsoft Access
recognizes the comma as the default field separator.
 
If you choose the Fixed Length format when exporting in DataEase, you will
need to create an Import Specification file in Microsoft Access before
importing the file.

 



0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
DSum for Access 6 43
Newbie needs help printing from a form. 10 19
Delphi Ado Query To Converts Joined Columns Into Rows Based on Primary Key 4 37
Sub Reports 8 21
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now