Im in the last few stages of building a website for a client. The website takes orders online for glasses lenses, theres a lot of data that needs to be entered for each order. At present I write the data to a database, but I need a way of sucking out all new orders to either 1 big txt file or seperate txt files. I can make this work but it makes the files at the server end, I need the client to be able to download this file(s) to a local machine so his machinery can suck in the data and start processing.
Any thoughts?
Ive been using VB mostly for my scripts as its normally very easy to work with, and been using visual studio 2008 as my IDE. Dont mind using any other languages but would rather stay on the micro$oft path as I doubt my host will allow PHP and VB. Also keep in mind at present I read a record from the database in my VB script, then write it to a file, then get the next record etc...
Thanks to anyone who can help!