Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote -2 down vote favorite

Is it possible to have a Server PC running a MS Excel Sheet to which several Thin Clients will be connected via TCP/IP having Barcode Scanners? The scanner's should dump their Data in the MS Excel Sheet in a First Come First Server basis? At the end of the day, the Excel sheet will be saved in Server PC's hard drive.

And, is there any other alternatives to achieve the above requirement?

Barcode Scanners have USB Output.

Schematic Diagram: http://i45.tinypic.com/2qlesnl.png

share|improve this question
think this belongs over on superuser.com or serverfault.com – Andrew Bickerton May 17 '12 at 9:18
Barcode scaners have USB Output, and in what they are pluged in. Are they act as HIDs on some machine or they have own memory and mode to send data in other way – adopilot May 17 '12 at 9:28
@adopilot, A person will scan a barcode, whose data will be passed through USB port. Need to dump it in Excel Sheet. just as the schematic diagrams shows. – Paddy04 May 17 '12 at 10:00
1  
I wonder how the requirement of excel came about, without being a db admin, but having experience connecting from outside to excel sheets, this sounds like the hardest way to achieve the goal. – Owe Jessen May 17 '12 at 14:09

closed as off topic by Nick Chammas, jcolebrand♦ May 17 '12 at 22:15

Questions on Database Administrators Stack Exchange are expected to relate to database administration within the scope defined in the FAQ. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about closed questions here.

1 Answer

up vote -1 down vote

No. Excel will not let more than one user open a file for writing. You could use separate files and manually merge them at the end of the day or you might write a program that writes the data to a shared text file. If you have Microsoft Access (the database program), you might cobble something together.

share|improve this answer
-1 as yes excel can let multiple users open a file for writing, though it is not a good idea regardless – Andrew Bickerton May 17 '12 at 13:02

Not the answer you're looking for? Browse other questions tagged or ask your own question.