splitting large flat table

[eggwater]

Hi I'm attempting to split a large flat table to make a relational database because it's gonna get accessed via the web using ASP eventually... and it needs to be slick with little redundant data etc etc...

if iwas starting from scratch this wouldn't be so hard - but i gotta keep the data that's already been entered...

anyone ever done this before?

if so any good tips i should know about?

just thought I may as well get a bit of input before I fly headlong into it...

my table data consists of

personal details - ie. name, address, DOB, disability etc
universitry course details
university accomodation details
duration of stay etc...etc...

the data pretty much splits itself into catagories and sub categories.

any thoughts would be appreciated?!

 

[namliam]

You will need to identify your PK/FK and relationships (1 to many, many to many, many to 1) to start with.

Then Hopefully you allready have them in your (flat) table. If that is true then you can work with queries only.

If you have no (potential) key values in the flat table you will have to work with vba, record by record splitting the data.

Those are my experiences/ideas anyway...

Regards

The Mailman

 

[eggwater]

have started my queries

keep ya posted...

not started relatin' yet

better get on it

cheers