SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-29-2008, 07:29 AM
| ||||
| ||||
 importing from .txt orange May 14, 5:16 pm show options Newsgroups: comp.databases.ms-access From: "orange" <orange...@mail.ru> - Find messages by this author Date: 14 May 2005 14:16:49 -0700 Local: Sat,May 14 2005 5:16 pm Subject: import complex data Reply | Reply to Author | Forward | Print | Individual Message | Show original | Remove | Report Abuse I've got a database in .txt file similar to this: BookName;Author;Year;ReviewedBy;Rating;Pages Nemesis;Isaac Asimov;1989;13,31,24;good;110 Sense & Sensibility;Jane Austen;1970;45,32;great;120 The Bicentennial Man;Isaac Asimov;1965;14;excellent;124 ... the data in field 'ReviewedBy' should be connected to names of people that read the book. I'd like to have a separate table in Access like this: Id;Reviewer 13;Bob ... 24;Jim ... 31;Tom How do I import that data into database?      |
|
02-29-2008, 07:29 AM
| ||||
| ||||
| Re: importing from .txt Hi This is a SQL Server newsgroup, therefore you may want to post to a newsgroup more specific to your subject. You can import a text file from the Insert/table menu. For your 'ReviewedBy' field you can define relationships using the Tools/Relationships menu. This will make sure that they are only existing users. To copy them into subsequent tables then you can write Append queries that will produce queries like INSERT INTO NewTable SELECT Id, ReviewedBy FROM LoadedDataTable if you view the SQL. HTH John <orangeKDS@mail.ru> wrote in message news:1116107071.499762.101180@g43g2000cwa.googlegr oups.com... > > orange May 14, 5:16 pm show options > Newsgroups: comp.databases.ms-access > From: "orange" <orange...@mail.ru> - Find messages by this author > Date: 14 May 2005 14:16:49 -0700 > Local: Sat,May 14 2005 5:16 pm > Subject: import complex data > Reply | Reply to Author | Forward | Print | Individual Message | Show > original | Remove | Report Abuse > > I've got a database in .txt file similar to this: > > BookName;Author;Year;ReviewedBy;Rating;Pages > Nemesis;Isaac Asimov;1989;13,31,24;good;110 > Sense & Sensibility;Jane Austen;1970;45,32;great;120 > The Bicentennial Man;Isaac Asimov;1965;14;excellent;124 > .. > > the data in field 'ReviewedBy' should be connected to names of people > that read the book. I'd like to have a separate table in Access like > this: > > Id;Reviewer > 13;Bob > .. > 24;Jim > .. > 31;Tom > > How do I import that data into database? > |
Linear Mode
