Kan ikke vælge tabel til tilføjelsesforespørgsel

Jeg har lavet en forespørgsel der opretter tabel5 og ligger data fra tabel1 ind.

And this works?



How to create a Microsoft Access Append Query:
1.Create a SELECT query to determine the records that will be appended. Apply any required query criteria
2.In the query design view, click on the drop-down arrow to the right of the Query Type button and choose Append Query
3.In the Append dialog box, select the table that you want to Append To from the list of tables in the current database, or select to append this to another database and either Browse to this, or enter the full file path including the database name

Ja, den første er jo en oprettelsesforespørgsel. Den kører uden problemer.
Men når jeg skal tilføje tabel2 til tabel5 er den ikke på listen jf- punkt 2 i det du skriver

without seeing th edB its hard to say what the problem is.

You could go into SQL view and do it in SQ then go over to design view to make any changes


INSERT INTO tabel5 SELECT * FROM tabel2

status please

Sorry for my late reply.

I ended up copy/pasting the records... it wa sonly af few hundred, but I still don't know what went wrong. (doesn't matter either)

Thanks for your assistance anyway :)

Well its nice to know you found a solution, but it would have been nice to have found the problem though.

And thanks for the points