Import fejl - Excel/ access

You will normally get this error when working with arrays/collections if you try and read an ellement outside those defined.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbenlr98/html/vamsgoutofbounds.asp

Not quite sure why you get it when importing from Excel. Could you explain how you are importing?

Jeg anvender import guiden i access..Ligesom jeg har gjort 100 gange før - Dog indeholder den en del funktioner..

En del funktioner? Is this your own code? If it is then I would imagine you have an error in your code where you are looping too many times or something like that!

Eller også fordi du f.eks. importerer et tal der er støre en Access datatype.
Hvis du har en datatype i Access der hedder Byte og rummer en max. numerisk værdi på 255, og du prøver at importere et talt der er større, mener jeg også du får denne fejl.

Det jeg har gjort er at lave et nyt Excel ark hvor jeg fjerner koden og kopiere værdierne til. Herfter prøver jeg at importere data og det virker!!

Is the code in Excel? You could just import the raw data and then have the code in Access to do what ever you are doing.

thanks, did you find the problem?

jeps - It also toke the codes into access and not only data - So its was the problem - I make a copi and said set in speciel value