Updating data in a linked table is not supported by this ISAM

Your not allowed to update with text files!
http://support.microsoft.com/default.aspx?scid=kb;en-us;828892

workaround is to import into an Access table then you could export again when updated

Thanks Terry

I have another problem in reaching home, which I do not think im able to solve without a change in the format but here it is anyway:

In my inputfiles I have a header with five fields all off type text.

My detail records contains of 11 fields
Tesxt, Text, num, num, txt,num,num,txt,num,num,txt

The problem is that the third field (text) in the header do not fit with the detail record type which is number and therefor disappears or give me a hard time.

I know that im working in a dirty solution but i need to know if I can do something smart to make it work?

Regards Flemming

Hi Flemming, your welcome to write in Danish if it makes things easier.

Not quite sure I understand the problem "...third field (text) in the header do not fit with the detail record type which is number and therefor disappears or give me a hard time."

are these fields supposed to be related or something?

Hej Terry

Jeg forstår din undren, det var noget vrøvl jeg fik skrevet. Den "interne_temp" tabel havde jeg ikke fået defineret som indeholdende felter af  typen tekst, så der var nogen konflikter, men dit svar "not quite sure i underst..." fik mig til at bruge mine begrænsede resourcer til at tænke mig lidt om :-)

og nu har har jeg fået lavet min konvertering i en fuldautomatisk version.
Tak for hjælpen.

mvh Flemming

selv tak

glad to hear you have it working :o)