Database grows from 30mb to 900mb using Access 2000

[Sailes]

I have written some code that splits data from 1 field
into 6 fields and then carry some validation on these 6
fields and write comments to a 7th field.

Running this against 40000 records, my database grows from
30mb to 900mb.

When I compact & repair the database the database size
return to about 35mb.

What can i do to release this 'temp space' as i'm
splitting the data. so that I don't have to keep
Compacting the database... is it my code and what?

Any help will be most appreciated
thanks

 

[JM]

I have written some code that splits data from 1 field
into 6 fields and then carry some validation on these 6
fields and write comments to a 7th field.

Running this against 40000 records, my database grows from
30mb to 900mb.

When I compact & repair the database the database size
return to about 35mb.

What can i do to release this 'temp space' as i'm
splitting the data. so that I don't have to keep
Compacting the database... is it my code and what?

Any help will be most appreciated
thanks

Are you splitting data from tableA into tableB maybe via tableC.

How are you parsing the data. Please post some of the suspect code.