How to import records from a excelsheet!

I ran into troubles when Im trying to update my records with an import-file.



This the situation.

1. Delete all records or drop the temporary table that youre going to hold the data in;

2. Import the data from the spreadsheat (excel 97)into the temporary table;

3. Run one or more updates queries on the temporary table to clean the data.

4. Append all the appropriate fields in the temporary table to the actual table.



The problem is that the above sitauation cant change the value of an autonumber field.

This means that the other records cant be updated.



Can anybody help me to update the records?

The autonumber field is a primary key.




Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories