Hello, Dmitry! You could save the excel sheet as comma separated values and then read and parse them line-by-line using python.
For each category (which is one of the columns) you can get_or_create a category record in the database and assign that as a foreign key or many to many relationship to the record of the main item. All the further details depend on your models and business requirements. Regards, Aidas Bendoraitis aka Archatas On 5/12/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > Hello, everyone! > > I want to implement some sort of importing data into my database from > excel. And i have a problem: this xls tables are huge and needs to be > normalized to relation structure, in other words i want to torn one > excel table to many with FK relationships between them, but i dunno > how to do this: in my python import function, or some kind of SQL > procedure, or there are software, which can do that. Please, advice > > Regards, Dmitry Shevchenko. > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
