Barcode scanner output to excel

Greetings,

I have a Symbol P470 barcode scanner. The scanner only have a RS232 cable to connect to a computer.

I want to know if I can scan every item in my inventory directly to an excel datasheet, access or text file ?

What would be the best solution ?

Thank you
tblincAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

MikeMcEvoyCommented:
Yes.

I use Tal Techs WinWedge RS232 Data Acquisition Software. You can have the RS-232 data feed right into a access database or excel file. I use it to feed the data right into an access table. It is easy to setup an the customer service at Tal Tech is awesome.

http://www.taltech.com/products/winwedge.html
point_pleasantCommented:
seems you need to get their software if you want anything more than a text file to import


see:


http://www.barcodediscount.com/pdf/Symbol/p370p470.pdf

andrevanzuydamCommented:
Symbol scanners usually come with a cradle option or a direct cable option,  I have successfully installed both with a RS232 to USB adapter which creates a virtual COM port under Windows.  This is very useful if one has a laptop without RS232 ports.

I prefer the cradle option for scanning with the Symbol scanner as it can store items in memory which then can be downloaded later to Text or Excel file.  You will need to program the scanner before use by using the manual provided with the scanner or available for download from here :

http://www.generalmanual.com/Scanners/Symbol-P470-General-Purpose-Bar-Code-Scanner.htm

Use a bar code font to create custom bar codes for your inventory if you wish to correlate stock codes with your accounting system.  A Code39 or 3 of 9 bar code is easy to use and does not involve check sums like commercial bar codes.  It needs to be prefixed and suffixed with a * character.

You can find downloadable TTF bar code fonts here, Code 39 or 3 of 9 is the top one :

http://www.adams1.com/fonts.html

I hope this answers your question completely.  I would be happy to assist with other queries if you have any.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

andrevanzuydamCommented:
One other thing I almost forgot to point out is that you'll probably need a software application that converts RS232 input to keystrokes once you have connected the Cradle or Scanner to your system.
You can download something like this:

http://www.freedownloadmanager.org/downloadsBill_Redirect_Serial_File_TCP_Port_amp_KB_50455_p/

I found the Symbian software difficult to configure and setup for the scanner and the  RS232 keystroke software was the simplest solution.
tblincAuthor Commented:
how can I download the file from my cradle ?
andrevanzuydamCommented:
Hi

The "file" is simply a stream of keyboard input, hence the software to convert RS232 data to keyboard input.  This application needs to be setup as a task bar application or service and configured to listen to the port that your scanner is plugged in with, some of these software applications can output a file however what I'm talking about will output directly to notepad or excel once you press your send button on the scanner.

Does this make sense ?
tblincAuthor Commented:
thx
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.