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
exporting the stock table to MS excell help
Moderators:daleadmin, Dale Harris, Alan, Andrew
- Dale Harris
- Forum Owner
- Posts:1171
- Joined:Sun Dec 28, 2003 10:19 pm
- Location:Chicago
- Contact:
Exporting stock table
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
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
Dale
Re: Exporting stock table
Fixed link:Dale Harris wrote: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
http://keyhut.com/postip6.htm#export
- Dale Harris
- Forum Owner
- Posts:1171
- Joined:Sun Dec 28, 2003 10:19 pm
- Location:Chicago
- Contact:
New user's guide
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.
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.
Dale
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: 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.)
In most DOS systems, you can simply type:
Code: Select all
ren file.TXT file.CSV
(As you can see, I prefer the old ways.)
Who is online
Users browsing this forum: No registered users and 152 guests