hjælp til import af csv fil via macro

Why use a macro, you can do it in code

Docmd.TransferText,,"TableNameGoesHere", "FileNameGoesHere", HasFieldNames

HasFieldNames can be True or false, true if the file has the name of the fields.

When you import you can also (i think) save the import specification for later use. This allows you to fine tune the iumport. Then you giv ethe specification name whne you import.

Docmd.TransferText acImportDelim ,"SpecificationNameGoesHere","TableNameGoesHere", "FileNameGoesHere", HasFieldNames

Årsagen til jeg vil bruge macro - er at det er nemmere for andre brugere bare at klikke på en knap - og derved på uploadet filen.

Det er en tabel med 21 kolonner og mange linier. Den skal tillægges 1 gang om måneden. Dette skal gøres af flere brugere. .....og jeg er ikke ekspert i kodning - endnu :-)

well I have to admit thatI am no expert in macro's :o) I never use them.
Doing it in code also allowes you to have a button which the user can press.

I dont see why using a macro shouldnt work the same as when you import manually, as long as you are importing the same file.

Try importing manually and at some stage you should (I think) be able to press an "Advanced" button". This allows you to save the import specification. Then when you create a macro to import you should be able to use the import specification. Maybe this helps. If not you can send me your dB and file and I'll see if I can find the problem.
ekspertenATsanthell.dk
AT = @

I'll have time tomorrow morning first if that sOK

stopper for idag - kigger videre i morgen. Indtil videre tak for din hjælp.

Hej Terry
Tak for din tålmodighed med mig. Jeg har nu løst mit problem. Løsningen var ganske enkelt, delvist det du beskrev, at anvende "advanced" i opsætningen af tabellen. Derefter lavede jeg en macro, der kørte dette specifikke "Specification name".

Thanks.
You should consider doing things in code, it gives you much more control over what your doing.