Copying data from a Union SQL View

[aron.ridgway]

Hi There

I'm trying to create an access table (with a Primary key) that loads in the data from a Union SQL view.

Im hoping there is a way of achieving this? Ive tried an append and create table queries which copies the data but still no primary key.

I've created a blank table with the fields i want but cant think how to import the fields from the view into it?

Am i better off loading the view into excel?

Any tips would be great!

thanks

 

[namliam]

Same thread here:
http://www.access-programmers.co.uk/forums/showthread.php?t=263995

 

[Cronk]

Does aron.ridgway always ask the same question twice?