exporting the stock table to MS excell help

[Payphone]

HI
how do i export the stock table to ms excell ? every time when export the stock table it saves as a TEXT file (TXT) But how do i make as a excell file (xls)




Thanks

[Dale Harris]

Payphone,

POS will not create an Excel formatted file. However it will create a comma delimited text file that can be loaded into Excel or any other spreadsheet or database program.

What you do is create the comma delimited text file. Open Excel and click to open a new file. At the bottom of the window that opens click on "File of type" and choose .TXT

Now click on the file you created and choose "Delimited" and then "Comma" as the delimiter and the file will load into Excel.

For more details click here. http://keyhut.com/postip5.htm#export

[GAWG]

Payphone,

POS will not create an Excel formatted file. However it will create a comma delimited text file that can be loaded into Excel or any other spreadsheet or database program.

What you do is create the comma delimited text file. Open Excel and click to open a new file. At the bottom of the window that opens click on "File of type" and choose .TXT

Now click on the file you created and choose "Delimited" and then "Comma" as the delimiter and the file will load into Excel.

For more details click here. http://keyhut.com/postip5.htm#export

Fixed link:
http://keyhut.com/postip6.htm#export

[Dale Harris]

GAWG

Since that link was originally posted I have released a new version of the POS program and therefore a new user's guide. That link was to the old user's guide.

[GAWG]

yupyup

[suamme1]

Just as a quick note, if Excel is installed properly, you can usually just rename the output file from file.TXT to file.CSV (Comma Seperated Values), then Excel will run with the file and automatically convert it. Don't forget to save your changes once you get in Excel though.


In most DOS systems, you can simply type:

Code: Select all

ren file.TXT file.CSV

or in windows, highlight the file and either press F2 or click on the name again.


(As you can see, I prefer the old ways.)