Importing text file?

[sasolini]

Hey,

I have a text file i wish to link up to one of my tables. The problem is that even if i try to import data from that file i get "Text file specifikation field separator matches decimal separator or text delimiter." message and after that one an err that the file cant be imported. Does anyone know why?

Thats the sample of my file:

'PV','045.302','KROG VEN S PNEU POG','JOHN-VALVE + AIR TORQUE','JV-9301NC-BW + AT051DA','','','','15','8','VANI','','1.4408','PTFE','ZRK'

 

[Bat17]

it sounds like a clash with your region settings, what is your decimal seperator?

 

[strep21]

Sasolini,
When importing the file, click on "Advanced" (down left).
Look at the Decimal Symbol, about middle of the screen, to the right. It probably says " , ". Change it to " . " (without the double quotest).

Eddie

 

[zestygirl]

Sometimes, cheating and doing things the easy way is the fastest (if not the fanciest) solution. Anytime I have trouble importing a table, I simply go back to my original file - format it identically (field order/field type) to the destination table and copy/paste it in. I assume you are trying to "append" records that are supposed to match the destination table? Another hint - if your origin table happens to be a word file - just start by making your word file an excel file (pastes a lot easier...) and again, this is a simple operation that will cut lots of hassle off the operation. I have copied/pasted thousands of records without incident for many years, so I have little doubt it can work for you.......

 

[sasolini]

thx to all of you ...

strep21 it works like magic