Inport data problems

[indesisiv]

I have just inherited a database to sort out and it is a nightmare like all inherited databases.

This database is going to be e-mailed out to several users. Each user will put data in to it and then send it back.
In effect there will be 20 copies of this database.

The problem begins here:

I have to find a way to import all of this data into one database for analysis.
BUT
There are 2 subforms.

Is there a way to do this.

I seem to think that the problem will come because they will all have overlapping numbers so that all of the subforms will in effect link together and not be with the correct forms.

Any ideas on this would be much appreciated.

Steve

 

[vix666]

I just wondered if the users you are sending it to are all located on the same network? If so then instead of sending seperate copies of the database you could just send a shortcut to them to link to the one version of the database, thus having no problem with how to import all the data.

What tables are involved in this form where there are two subforms? How do they relate together?

Vicky

 

[indesisiv]

They are all on different networks unfortunately.

The sub forms are both on the main form and are both 1 to many.

I am beginning to think that i need to create my own unique ID for each form using a prefix of my own for each table.

Then they should link in fine.

Does that sound like it will work.

 

[vix666]

Hmm I think as long as you have your primary key for the main form being unique and the primary key/foreign key values for the subforms either being entered or autonumbered, so that there is data there, then you shouldnt have too much of a problem.

When you import the data you will be importing the data that is stored in them, as long as you import the parent records first and then do the child records (the subforms) then it should go in fine. You can then write an update query that will take all your data and update it into one table.

Hope this is of some help

Vicky

 

[indesisiv]

Sounds good in theory. I'll give it a go and see what happens.

Steve