Forum Home
Press F1
Thread ID: 84811	2007-11-19 22:31:00	Access Problem	Obelix (752)	Press F1

Post ID	Timestamp	Content	User
613036	2007-11-19 22:31:00	Heya all, I am hoping someone can point me in the right direction. I have searched on the net and have not been able to find an answer to this problem I am having. I have am trying to update an access table where the data is coming from a different source. What I have is:- One file with ISBN, amd SUBJECT1, SUBJECT2, SUBJECT3, SUBJECT,4 SUBJECT5 and SUBJECT6 The next file has ISBN and CODE The third file has CODE and NAME What I want to do is get the NAME field from file 3, and insert it into one of the 6 subject fields in file 1. Can anyone help me to achieve this. Thanks in advance.	Obelix (752)
613037	2007-11-20 10:14:00	I'm not sure exactly what you want to do here. What are the separate files here? Different MDB files? Spreadsheet files? My advice would be to store all data in one database. A database is pretty pointless if a human still has to do all the searching. I know nothing about Access but have used other database systems. You probably want something like this structure. I've assumed that ISBN values are unique and the code is an internal identifier I know nothing else about. Tables: Book(ISBN, Code, Name), Book_Subjects(ISBN, Subject) Constraints: Book_Subjects[ISBN] <= Book[ISBN] Underlines indicate the primary keys. I'm not sure whether Access supports primary keys over two fields so you may also need an ID field in the Book_Subjects table to act as a primary key instead. Subjects 1 through 6 should all be split in to separate rows in Book_Subjects to structure the data in a way that the computer can understand. Help with importing data is difficult without knowing how it's stored. Could you post this?	TGoddard (7263)
613038	2007-11-20 16:50:00	create 3 tables which are linked to the text files you have indicated then go to file ("file... get external data" and use that wizard to link to your text files for each table) then once the import is complete design a query based on all three tables to extract the data you wish.	beama (111)
1