Importing Data from Excel to Access

[Jack_Maloney]

Hi,

Ok, so I have a problem that in theory should be straightforward to fix but I cant seem to do it!

I have an excel spreadsheet which contains a number of columns which each relate to a column within access. All fields except one will be imported into only one table called 'Master table'. The other key is a foreign key e.g. at present it is called 'Project_Name' but will be changed to 'Project ID' and will need to pick up the primary key of the related project in the 'Project table'.

The problem I am having is how do I get the 'Project Name' column into the 'Project' table, remove all the duplicates and then get the 'Master table' to pick up the related primary key 'Project ID' in place of the 'project name'.

Any advice on how I do this would be much appreciated!

Thanks

 

[John Big Booty]

Perhaps the sample I posted in this thread will give you some ideas.