Access 2007 tekst (txt) eksport fejl 3441 engelsk/dansk styresystemer

http://www.access-programmers.co.uk/forums/showthread.php?t=173083

'3441' "Text file specification field separator matches decimal separator or text delimiter"


You need to look at which field separator your using, and also the dcecimal separator in numbers. If they are the same then it will give problems.

Try changing regional settings on DK machine to English, just to see if it helps.

sorry supertekst, for some reason your comment hadn't show up.

Ok terry :-)

Jeg har forstået det som at der som følge af dansk styresystem skal laves en spec for min eksport som skal gemmes på hdd. jeg kan dog ikke helt gennemskue hvordan.

Jeg har gemt en eksporthændelse i databasen og forsøgt at kalde den i koden. Får dog følgende fejl:

The text file specification <name> does not exist. You cannot import, export, or link using the specification. (Error 3625)

Microsoft Access tried to import/export/link to a text file using a specification table name that does not exist in the MSysIMEXSpecs table of the database. Re-create the link using a valid specification table.

In newer versions of Access there are actually two ways to make export specifications, and for some reason one of them isn't recognised as a specification when using DoCmd.TransferText


Anyway, try this.
Choose query to export.
Then choose External Data Menu followed by Text File (to right of Saved Exports.
The filename is defaulted to name of query + .txt. Change .txt to .csv.
This now gives you much more flexibility over how you export the data.
There is an Advanced button lower left. Press this.

Here you can choose what Decimal symbol you want in the file, and also Field Delimiter. Change these and make sure they are not the same.
The Save As button lets you save the name of the export specification, this is the name you use in
DoCmd.TransferText

Give it a try.

Eksporten ser fin ud men jeg får følgende fejl?

DoCmd.TransferText acExportDelim, , "ExpShopUpdate", sImportFile, True =>

Microsoft Access-databaseprogrammet kan ikke finde objektet "ExpShopUpdate". Kontrollér, at objektet findes, og at du har stavet navnet og stien korrekt. Hvis 'ExpShopUpdate' ikke er et lokalt objekt, skal du kontrollere netværksforbindelsen eller kontakte serveradministratoren.

ELLER

DoCmd.TransferText acExportDelim, "ExpShopUpdate", "qry_shop_update", sImportFile, True =>

Tekstfilspecifikationen "ExpShopUpdate" findes ikke. Du kan ikke importere, eksportere eller sammenkæde med denne specifikation.

? hva' gør jeg galt.

I cant see how your creating the specification so I cant say what the problem is.

If you open External Data menu and then press saved exports, can you see the name of the specification here?

ja... og eksporten fungere uden problemer fra access brugerflade?

"ja... og eksporten fungere uden problemer fra access brugerflade? " ??

Not sure that answers my question

Ok, I assume ja means you can see the export specification under Saved Exports and that it also works running it from here.

As mentioned earlier:
In newer versions of Access there are actually two ways to make export specifications, and for some reason one of them isn't recognised as a specification when using DoCmd.TransferText

And this happens to be the specifications saved under External Data/Saved Specifications.

Again, I dont know how you are creating the specific, but if you followed my earlier instructions and actually pressed the ADVANCED button, as I also said,
"The Save As button lets you save the name of the export specification, this is the name you use in
DoCmd.TransferText"

You have to give your specification a name here and saved it, and this is the name you have to use, NOT the name under External Data/Saved Specifications.

Hi Terry.

I just realised that I mistakenly thought that it was the "save export steps" you meant, and this I did not do :-o

I'll try it out when I get my hands on the danish pc.

Jan

OK

Hi terry

Finally it seems to be working.

I saved the configuration in the "advance" dialog and added the name to the code like this

DoCmd.TransferText acExportDelim, "qsu_xport", "qry_shop_update", sImportFile, True

Thanks for the help :-) br Jan

de points der så...

Øh - hvordan er det så lige at jeg tildeler dig points?

Great :-)

You'll need an answer from Supertekst and then it should be straight forward

If you intend splitting them that is.

thanks