Sharing Data

[ddrew]

I have the ability on my database to export one record to excel. The raeson for this is so that I can email the record to another person.

The record has an autonumber ID. The person that I share the information with my well have a different record with the same autonumber. If they try to import that record, my guess is that it will fail as it will replace duplicate numbers.

How can I get around this problem please?

 

[pr2-eugin]

Is the other person just adding the record into the table? If so why don't you not export the autonumber column. So they can just do a normal append when importing?

 

[ddrew]

Is the other person just adding the record into the table? If so why don't you not export the autonumber column. So they can just do a normal append when importing?

Thats what I was thinking, how do I export the table but not that field?

 

[pr2-eugin]

Create a Query based on the table, then export the query.

 

[ddrew]

OK so that creates a problem, if leave the ID out of the query, how does the query know which one to export?

 

[pr2-eugin]

You use the AutoNumber column in the WHERE clause but do not need to export it, something like

SELECT ColumnName1, ColumnName2 
FROM tableName
WHERE autoColumnName = 65;