FTP af current record

I think you may need to export the current record to a text file first, but take a look at this link for some ideas.
http://support.microsoft.com/kb/164005

Or maybe use a query in the transfertext which has a criteria so that only the current record gets transfered

hi Terry

I get an error: Error 13 Type mismatch
I have checked and double checked, the names of columns are the same.

Tha code:    DoCmd.TransferText "acExportDelim", "specordre", "fspordre", "C:\testlager.txt", False

Can you help med?

regards Flemming

"acExportDelim" = acExportDelim

(no "")

thanks for your help.

Do you know how I can help getting my æ ø and å right in the textfile? After eksport they are converted to different caracters.

regards flemming

If you open Notepad and enter danish charcaters arentthey displayed correctly? If so I would have thought that they would also be exported correctly.