Recent content by Jenny1

I cant delete or change is as the message says this is part of a relationship. So I need to use your other method BUT if I add the numbers 1-690 how will future records start at 691?? And seocndly what do you mean when you say append - do you just mean copy and paste??

Because currently I dont bring the autonumber across, I then copy the current data and paste it to the table I want it in. When I do this I obviously dont paste anything to the auto number field. This field should fill itself. And it does but it fills itself with a number that begins with...

Currently I am not uploading to the tables that do have relationships, I am updatting to a new unrelated table and then attempting to move the data across to where I want it.

Hi Gary, please explain again (sorry) Option 1 or number them your self in xls 1 So your saying number each row in xls format then do the import thing again?? Option 2 Or leave the auto field blank - it will do the numbers for you Again do you mean leave the first coloumn blank and import...

I see BUT they are increasing sequentially : org_id 40247345 40247346 40247347 40247348 40247349 40247350 40247351 40247352 40247353

True, but its a bit strange that excel decides to generate a number that begins with 40246824! I dont understand why it would do this

Rabbie to reset the auto number you need to delete the auto number field - I cant do this because the auto number field is the primary key, and I am warned that i need to redo the rleationsships before I delete

the column is auto increment and they are sequential I assume because normaly they increas from 1 upwards

Can Anyone help with this I am desperate?

okay - as a test I copy and passted the data across - problem is its given me auto incremented org_ids which start at a ridiculously high number for example the org_id of the first record is : 40243719 Why isnt it starting at 1?? Any ideas tips or advice please

Microsoft Access append queries are good for adding data to a different table where the data is based upon a selection criteria. However, append queries are not always the most efficient way of adding records to another database. If you need to add all records and fields from one table to...

That sounds exactly like what I want to do. How do I do this, I feel like I am nearly there. Please advise

I have just attempted this method - and realised once I rename the new table (which stores the data) to match the name of the old table It will replace the old table (which is what I want) but it will also delete the relationships of the old table so I will havr to do all the relations hsips...

is it just a case of adding the additional auto increment field and then renaming the new tabole so that it matches the old one. and deleting the old one.

Hi, Thanks for your replies - im only uloading about 600 records. Anyway goodnews, I have managed to upload the organisations data to a new table - like you said. All four fields exist in theri own table. Now I have to get this information into the 'real table' and avoid entering anything...