Makro

ok..

1) har jeg selv løst.. men hvordan får jeg den til automatisk at bruge en Import-/eksportspecifikation og så oprette tabellen bagefter?

First I would NOT use a macro I would do it all in VBA. Make a form with a buttonto start the import.

1) Use the common dialog to select the fiel and then use the Transfertext to import the file you choose.
2) I assume you want to us ethe import spec. while importing. You can use an import spec. with Transfertext

3) Make a report using the wizard then place a button on the form again using the wizard, to open the report you just made!

that was an answer1

Uhmmm

How do I insert a form in the access VBA editor?

If I start it in Word I can use "Insert -> UserForm"

That possibility is not there if I start the VBA editor from Access..

In Access you select thhe form TAB  from the database windows, then you choose new.

Then in design view you can select controls to put on the form from the toolbox!

ah ok.. found it =)

hmmm

When I try to add Common Dialog component to select file it complains about:

"OLE-server is not registered. Reinstall OLE-server to register it"

uhmm? What's that?

Not sure, I think it snecesary to have Access developer edition!
Anyway here is a link to another dialog control
http://www.mvps.org/access/api/api0001.htm

You can download and example too I think!

Thanks a lot for the help :)