Make comments, ask questions, or just complain about the software on this site. Or comment on any educational software.
Please note that by clicking on links that may appear in these posts that you may be leaving the Dale Harris Educational Software website and that the content of those sites is the sole resposibility of the authors of those sites.
Moderators:daleadmin, Dale Harris, Alan, Andrew
-
WindsorSwingKid - Posts:1
- Joined:Mon Oct 11, 2004 6:48 pm
Importing MS Access Customer Data into POS 6.09
Post
by WindsorSwingKid » Mon Oct 11, 2004 6:56 pm
I have an existing customer database of over eight hundred records in MS Access... I have looked throughout the Web site and have not found any way to convert/extract/import the Access DB into a format that POS 6.09 could understand... Is there any way to do this? I have already:
- checked a small .CST file to see what fixed column width formatting is necessary...
- used Excel to handle some text manipulation and concatenation to set the fixed field widths...
- and used Word to copy the extra special characters between the records of the original .CST file and paste them between each of the new records...
I would not want to re-type all of this information over again from Access into POS... Thanks...
John...
-
Andrew
- Site Administrator
- Posts:822
- Joined:Sun Dec 28, 2003 3:40 pm
- Location:New Zealand
Post
by Andrew » Tue Oct 12, 2004 1:53 am
There is currently no import customers function. If Dale were to implement one.
It would likely be from a CSV (comma separated value) file and the data would have to be in a particular order as for importing stock.
Dale may provide further info on the file format but writing your own CST file could yield it's own hidden hassles...
DHPOS Veteran (from v3.46, July 2002)
Who is online
Users browsing this forum: No registered users and 13 guests
