asked on

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

MikeMcEvoy

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_pleasant

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

ASKER CERTIFIED SOLUTION

andrevanzuydam

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

andrevanzuydam

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.

tblinc

ASKER

how can I download the file from my cradle ?

andrevanzuydam

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 ?

tblinc

ASKER

thx