importing individual data from different databases

[phillip dziewior]

Can anyone tell me if I can import data from an access datatbase to a table alread in existence in my A5V7, and if so where I can find the information on how to do so. Thanks

[Robert Adler]

phillip:

use the import feature under File in main tool bar. Third selection is for ADO import genie.

you will import the Access file into a new dbf. Then append the data to the file you want to load.

I hope this helps.

bob adler

[phillip dziewior]

thank you I will try this.

[nodenet]

I have tried to do this but decimal places are cropped from numbers with decimal places in the original Access table. I have edited the resultant table in table structure. I set the number fields to 18 width 2 decimal and when I try an import into it it sets them back to 20 width and 0 decimal.

[Robert Adler]

phillip:

this sounds like a bug. I believe there had been a similar problem with Excel in the past.

Send a bug report to Alpha. They may need a sample data file to test with.

i hope this helps.

bob adler

[phillip dziewior]

Mr Adler

I have attempted what you have suggested by appending the record, but what it did was replace an existing date with the appended date. What I want to be able to do is go to a table that I have imported and add a specific data field to an existing table. In this instance what I'm trying to do is take an employee's training date from 2004 in one table and add the training date reported for 2005 into the table for training dates of 2004 for all of the employees.

[Robert Adler]

I have attempted what you have suggested by appending the record, but what it did was replace an existing date with the appended date. What I want to be able to do is go to a table that I have imported and add a specific data field to an existing table. In this instance what I'm trying to do is take an employee's training date from 2004 in one table and add the training date reported for 2005 into the table for training dates of 2004 for all of the employees.

The append operation should add records. new records do not replace existing data. It sounds like you want to post the old records.

the new file must match the old on some key field(unique) then replace the date field with the new value. Posting will permit you to replace, add, or subtract from a field.

if you are doing an append and then want to assign a particular value to a field perform an update against the file changing the fields in question.

I hope this helps.

bob adler

[phillip dziewior]

importing individual data fields

Mr. Adler

Being a newbie with this program and with programming in general I must be missing something or doing something wrong. I continually try to use the append function to import 2004 dates into a table that already has a 2005 date field and cannot, I have even edited the tables so that each table has the same number, type, and names of data fields in hopes that the data will import and as of yet it has not. Are there any availabe examples of how to perform what I want to do other than what is provided in the help file for A5V7?

[Dave McCormick]

OK - you have two tables. One with 2004 data and one with 2005 data?

And the fieldnames, types, and sizes are the same?

When you define the append, make sure that the Append drop-down is set to "all." It should not be set to "Unqiue Only" or "Unqiue Replace Existing."

When the operation is complete, make sure you haven't filtered out the records. (Click the Show All button on the toolbar.)

[phillip dziewior]

Retrieving data from seperate tables

Mr. McCormick

Your information along with the information received from Mr. Adler in a prior post has helped, thanks. What I found was the the entire table consisting of first name, last name, MI, and training date had been indeed added to the Master table, I just didn't scroll down the table before to see it had been added. What I'm trying to do is this. table 1 has the following fields: Last Name, First Name, MI, and Qualify date, table 2 has the same fields as table 1 with the exception of the fact that the dates in the qualify field are different in table 2. What I would like to do is add the field name "date qualified-05" and the data in the field from table 1 to table 2 which currently has a field name "date qualified date-04" and let A5V7 make sure the data is attached to the correct name as well, can this be done?