joined:Jan 1, 2010
Hi guys, sorry i seem to always come to here when im at wits ends, not really sql indepth but still a problem i have not been able to work out..
basicly im opening a shop, and im developing an epos system, i also have an online shop. i want to be able to share data between the two easily. both the website and epos software use csv's to import and export data but in different formatting, ideally id like a nice spread sheet, with all my product data and for there to be two copies of csv files generated from the data of the spreadsheet that updates automaticly, so i can change prices and add products on the master spread sheet and use a marco to update these to the website and till at end of day. is this possible? if they used sql databases i can imagine it would be easyier but if anyone has any ideas it would be greatly appreciated. obviously linking two spreadsheets is easy but csv's dont save the formulas that allow it. unless theres a program that can do this and generate them?