How to insert data from comma delimited file

[virtualweb]

Hello:

Im a web programmer that never used excel.

I have a new customer who is an accountant and who with excel he designed himself an accounting processing application.

He wants me to make an online tool to capture data he needs from his customers and this data I will be supplying to him in a comma delimited file.

He now needs a way to migrate the data from my file into his excel accounting application.

The data in my comma delimited file is saved in columns that matches his columns in his application. He currently is having his secretary copy/paste every single item in every column and in every row of my file by hand, and entering it in every column and row of his application which is ridiculous.

Im sure there may be an easier way to migrate this data

If you can help ill appreciate it.

virtualweb

 

[Devin]

You can import many kinds of data formats into Excel including comma delimited files. In Excel 2007 under the "Data" ribbon is a function call "From Text" which is basically an import data wizard. It has many options that are probably what you are looking for. I believe older versions of Excel also have this feature.