importing value from text file

[dorisr]

Hi All,
I need to import some values in the format comma delimited in an access table.

The format of the text file is like this :

level, glno
800000000,02.75.20000000
...

but when I import this in msaccess table, the value glno get's converted in this format 2.75.... It can't receive the text format 02.75.20000000.

I'M new to this, can anyone help me ?
Thanks Doris

 

[Kiwiman]

Howzit

When importing access must be interpretting the field as a number format. You want to import the field as a text format. You should be able to chagne the data type of the relevant field during the import...

 

[dorisr]

Thanks Kiwiman,
I have an existing table and the format of that variable is text...
I tested in my .txt file and when I put this it work ok :
800000000,"02.75.20000000"

But Ms Access should assign the value the same format than original....
I don't know how to set that....
Please help me,
Doris

 

[Kiwiman]

Howzit

If you are using an import spec, then try importing again, and when you have selected the import spec, check and see what data types are applied against the relevent fields.

If you are not using an import spec, It is the screen after you select which table to import it into. This is where you can change the data types...

 

[gemma-the-husky]

this cant be right

value 02.75.20000000 isnt numeric

 

[dorisr]

Yes this is refer to a GL number, it should be a text variable.

I was doing my comma delimited wrong...
now it work fine...

"800000000","02.75.20000000"

Now, I want to change the , for a ;

Thanks all for your help,
Dorisr