normalising table with a fields containing CSV data 
Author Message
 normalising table with a fields containing CSV data

I recently post a similar request in m.p.a.queries but realised I'm better
off asking here.

I've got a table imported from an old flatfile database.

Several of the fields contains several items of data separated by commas.

How can I get this data decomposed into it's second normal form?

Take a look at http://www.*-*-*.com/
created using MS Access together with a little piece of software called
dbtoWeb that helps convert it to something that looks half decent. I'll
eventually port it to an SQL server but that's after I've got the relational
model sorted out properly.

As you can see, There are a several DJs playing in several rooms. At the
moment, I've got a fixed number of fields (5) for the Rooms (I've used
dbtoweb to not print any line that's empty) and the DJs are entered as a
string, separated by commas.

What I want to do is normalise it so that (a) the number of rooms is
variable and (b) each DJ entry is on a separate record.


If I've got things right, I've got two different problems, both relating to
normalization. (1) How to get all that csv data into separate records. and
(2) Normalize the Number rooms.

I think I (2) is more of a problem best suited to queries (still need some
help there) but how about (1)? That's a coding problem if ever I've seen it.
Thanks to some help from people (Hello Jethro) on m.p.a.queries, I can get
the data into separate fields but not records. Maybe I should just do that
and then normalize but I can't help thinking there's a more elegant

Dale Walker

Sun, 28 Mar 2004 23:23:40 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Update tables containing Key fields

2. How to search a Table based on a text field that contains special chars

3. Import CSV but splitting the import data into two tables

4. Changing Data Type while linking table to a CSV

5. Function to return data contained in a table

6. Normalizing non-normal tables already containing data;OR changing columns into rows

7. Changing a field to Read only when form sent if it contains data

8. How to find out if table contains data?

9. Write ADO Field containing binary data (files) to the file system

10. VB3 appending a field to a table, then entering data into the new field

11. Read CSV file containing quotes

12. Inserting Data into LONG data type field in an ORACLE Table


Powered by phpBB® Forum Software