Importing new fields (and their data) into an existing table

[ick64]

Hello all,



I have a simple table with 04 fields and 2.700 records. Now I would like to add/import data related to 10 additional fields into those records.

Is it possible? How can I do it?


Thanks a lot!

[ranman256]

1. save the file (excel, or text) to a generic name everytime: File2import.txt or File2import.xls
2. attach (link) the file as an external table, like tFile2Import
3. make a query that appends data from tFile2Import table to the target table.
this query would use * to import all fields with the same name, but if the 2 tables dont have the same names, you must add the source fields and target fields to the query.
4. put this query in a macro, run the macro.

Once this is done, the import steps are now:
1. save the new file and overwrite the old one
2. run the macro
done.

if you get new fields, simply edit the append query, save.
(but if all fields in source and target are the same , theres no need to edit if you use the * )

[ick64]

Thank you ranman - I will try it and revert.

[orange]

Is you current table normalized?
Is your proposed new table with the additional fields normalized?
Review this to avoid a structure problem.
Good luck.

[ick64]

Hello all,

Based on the comments above - and as I am just about to start using the data, I figured out I would better have a new table with the proper fields instead of adding fields to an existing table.

Thanks for the input and comments!