Sammen hæng mellem et Excel dok. og en Access tabel-database

Prøv at præcisere lidt mere hvad det er du ønsker.

Hvis det er for Access til Excel, så prøv at markere det ønskede i Access og tryk ctrl-c, i Excel vælg Rediger, Indsæt Specielt og på dette faneblad vælg indsæt kæde.

Hvis du vil have data til Access fra dit regneark kan du linke dit regneark til Access som en tabel: file\get external data\link tables (vælg *.xls som type)

Hvis du vil have data fra din Access database til Excel kan du benytte Excel menuen: data\import external data\new database query (du kan både linke til en tabel eller en forespørgsel)

Begge dele kan opdatere dynamisk når der ændres i sourcen

Når jeg

nikolaj lund>Hvorfor har mugs fået 150 points når du IKKE har fået svar på din spm. ?

terry > Good morning. The user has got a correct answer on the question "How to import an Excel file into Access."

I think, that nikolaj_lund accepted My answer on another question, with out trying it first. But that is not My problem, my answer was correct.

nikolaj_lund is not familiar with eksperten, and if he wants the point back, he get them. But I want some GOOD arguments.

mugs>Yes I know that you gave nikolaj the answer he asked for, but what I dont understand is that he keeps creating new questions concerning the same problem. So there is no need for you to give any points back at all, but nikolaj needs to comment the answers/comments given or we can not help him.

terry > I agree with You, that nikolaj simply needs to give an explanation concerning new questions about the same problem.

Further more, he must understand, that we don't sit by the screen the whole day just waiting for a new question or a new comment.

The original question was how to import an Excel file into Access. A later question was was how to make a link between Excel and Access. He also got a correct answer on that, but accepted his own answer.

So maybee - the next question is from us, asking a coadmin to give some information to nikolaj, how to behave on this community.