Somebody plssssss HELPPPPP !!
I am trying to convert my data from EXCEL to TBL format, so that I don't have to re-key in all the items again, if I were to switch over to DALE's program, wondering is this possible ??
I have been trying to convert the file, but still fail !!
Can anyone HELP, plssssss !!
Very much appreciate in advance.
TQ.
Converting excel file to *.TBL !! Is this possible ?? HELP !
Moderators:daleadmin, Dale Harris, Alan, Andrew
Yes it is possible, but you have to have everything formatted just right. Actually you save the spreadsheet in Excel as a text file (CSV).
It is in the online users manual under heading 37 - Stock Table. It is on the "Next Page" a ways down. It is much easier to download the Word Version of the users manual it is on Page 66 & 67 (do a find for "importing" or "Excel" and it will take you right there.)
I did do it. The manual was not lying, everything did have to be perfect though and it take me a few tries to get it right.
Hope that helps.
It is in the online users manual under heading 37 - Stock Table. It is on the "Next Page" a ways down. It is much easier to download the Word Version of the users manual it is on Page 66 & 67 (do a find for "importing" or "Excel" and it will take you right there.)
I did do it. The manual was not lying, everything did have to be perfect though and it take me a few tries to get it right.
Hope that helps.
-
- Forum Regular
- Posts:83
- Joined:Sun Jul 10, 2005 4:24 pm
- Location:United States-New Hampshire-Rochester
- Contact:
just look
If you look at the file called stockt~1, that shows you the format that everything needs to be into. Just look at charcter limits and remember that the stock number field can contain numbers only. to try this, make a copy of your current inventory file in excel and a new .pos file and stocktable. change the items to to the maximum of 13000. then try it. read the manual too!
Good luck
Good luck
Graham Wakefield
Wakefield Tech Services and Mobile POS
Wakefield Tech Services and Mobile POS
- Dale Harris
- Forum Owner
- Posts:1171
- Joined:Sun Dec 28, 2003 10:19 pm
- Location:Chicago
- Contact:
.XLS files
Dale
Who is online
Users browsing this forum: No registered users and 141 guests