Search results

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...

Ok Guys Ive tried soo hard and this is what happens. Right click and import Choose the file I want to import Get message saying - your data seems to be in a delimited format, if it isn’t then choose the format the more correctly describes your data. Delimited format is checked by default –...

Sorry If I am mixing this up, But yes I have two tables, First I am going to insert the organisations and then the people, I have arrange the data in two tables. When you say use the wizard - are you saying rightclick on the main page and select import? OR are you saying - use the wizard...

The data is coming from a file with extention .csv looks exactly like a excel spreadsheet but only a single page. I have attached the database - as you can see from the database, I want to upload to two tables, one is called people and the other organisations. I have organised the data so that...

I dont get what you mean, In fact I am not sure how I would go about importing. Attached is my database, I will be importing People and Organisation data. What woud be the steps to do this??

Someone recently answered my query with regards to uploading data to an access table. The first coloumn is an auto incremented number. Will there be any problems with importing data - when one field is auto increment? Obviously I wont be uploading values for this column - can that be done?