Export Label Data From Bartender Then Import To Access Follow
I have an Access DB for warehouse inventory. I use the "get external data" procedure to import bar code scans from an Excel file generated by the MC9190 Windows Mobile scanner. Up until now I have only had to worry about scanning bar codes that were already on the individual pallets and importing the file to generate the shipping docs as well as update the database.
We now have the need to generate labels with bar codes and text for a different customer and apply them to the pallets (as opposed to scanning existing labels). I want to know if the act of generating or printing the labels based on existing DB fields (using data entry in Bartender?) can at the same time generate an Excel file of all data for a particular batch or session.
I guess another way to look at it would be if I printed a batch of labels for a receipt of goods and then scanned each bar code and imported the data like I do with existing pallet labels like my example above. Seems like I should be able to capture the label data without the extra step of scanning the newly printed labels.
Hope this make sense to someone. Any help would be appreciated.
Fernando Ramos MiracleModerator
Please sign in to leave a comment.