We have a database of products (Access)
From that database I am defining the Quantity field as an Integer (no decimal places)e.g 49
I then export to CSV
If i load the csv file intto Excel, the Quantity field shows as an Integer e.g. 49
When I try to import to store manager (Standard not the extra module) the quantity field is shown as decimalised e.g 49.00 and on import it is not picke dup resulting in the quantity field as ""
Dec 24, 2012
Thank you for your post.
It looks like you have selected different separators while exporting and importing your products.
Please make sure that the separators are the same, and pay your attention and "Quote string values with" option.
No, it is not to do with the separator. If it was, all the fields would not be correct
Anyway, I have solved the problem. It seems that in Microsoft access even when you tell the field to be an Interger, it does not always force it. Then, because of the quirk, some csv viewers will show the integer and some will not
In order to force the issue, in the Access query I had to use
And now all is well
Dec 26, 2012
Thank you for keeping us informed and thank you for cooperation.