How do I export Flash values into an Excel document and vice versa?
edited November 2009 in Internet & Media
Let's say I'm a doctor and I want to use keep track of my patients' particulars and other details in an Excel Spreadsheet, details like when was their last visit, what allergies they have etc. I want to make something like a form where I can call and insert values from/into the Excel document using Flash. Any known way to do it?
If you must use Flash, you might as well have it write to a database and then export the data into Excel, or within Excel connect to the database using ODBC.
Access would be a better solution if its something that is localized. You'd have a form and data up and running in minutes.
Yes its called Base. Essentially the same functionality as Access. There are wizards and sample DB's that will probably do what you need to do with minimal changes.
Ditch the Excel idea if you are planning to store a lot of data. Especially health data. I'm sure laws are different that here in the States so you don't have to deal with HIPAA.
not me actually. Haha. My boss keeps records of the staff's monthly reports, and she wants an interface so she can edit, add, display values in an excel document easily without the hassle of looking through the whole list (though there's a Ctrl+F function). Not really a lot of data too. Don't understand how humans can turn so lazy. Haha.
Is it possible for me to have a column in the DB, lets say it's called "Leave Dates", to have multiple values in it? I mean, I can put the values as a String datatype, but what if I want to add a single value to the existing string without reinserting the whole dammed string again?
It's like Staff member John took annual leaves on 21 Jan and 22 Jan. So in the DB, under the 'Leave Dates' column, the data under the name 'John' should be something like, say, "21/01, 22/01" if it were a string. Now John takes another day of leave on 2nd Feb, and so I want to add the value "2/2" to the DB. How do I just add 2/2 to the column but not retype the whole String of "21/01, 22/01, 2/2" again?
Its better to keep dates as a date field. Then just add a new row for each time an employee takes a leave.
Actually, if this is to track Leave of Absences, you should really have a "Leave Start" field and a "Leave End" field. Here is a simple structure without knowing your situation. I figure you probably aren't "linking" tables yet, so instead of Employee# you can probably have the employee's first and last name fields just to get you by. If an employee isn't back from leave yet, the leave date can be blank, thus, those that are blank are out on leave. You can also calculate the length of a leave by subtracting leave start from leave end. Hope this helps.