Convert Excel file into Text file

[polina]

Hello,

I have this task.
I need to convert the excel file into the text file before I import it into the the Access table.

While I convert it into the text file I need to take into consideration the scientific numbers that spreadsheet contatin, so they would be converted properly.

I do not know how to make the conversion of excel file to text file. I also do not know how to deal with the scientific numbers while converting them into the text.

If anyone knows or have an example or knows the sources where I could read on that, I would be greatful if you shared it with me.

Thanks a lot.

 

[NOL]

If you are going to import the file into an Access table ultimately ,
Then why do through the process of converting it into text,
when u can directly import it as Excel.

Maybe I haven't understood your question .