Symbol Technologies AccuScan Palm Pro Linking AccuScan Palm Session Data to an MS Access Table

Page 30

Chapter 5: Managing Data

5.4.3Linking AccuScan Palm Session Data to an MS Access Table

Microsoft Access is an affordable and popular database that can be utilized to manage AccuScan Palm data. To import AccuScan Palm session 1 data, file name S01_data.txt, follow these steps:

1.In MS Access, open your database or create a new database.

2.Select File.

3.Select Get External Data.

4.Select Import.

5.In the Import dialog box, select Files of type: Text files (*.txt).

6.In the file name list box enter you the path to S01_data.txt.

7.Select Import.

8.Follow the Import Wizard steps to complete the import.

5.4.4Linking AccuScan Palm Data to an MS Excel Worksheet

MS Excel allows text files to be opened directly in Excel. Following just a few simple wizard dialog screens allows most users to painlessly view their data in an easy to read MS Excel worksheet.

1.In MS Excel, select FileÆOpen.

2.Browse to the AccuScan Palm generated text file.

3.Select the file and Click Open.

4.Answer any questions regarding the type of data file as is appropriate.

5.You should now see your AccuScan Palm data displayed in MS Excel in a familiar spreadsheet format.

5.4.5ODBC Link to Data File

You can also create an ODBC DSN to point to your session data. One DSN could point to your downloaded data file and another DSN could point to your upload data file. An ODBC DSN is a great way to link your Accuscan session data files to any ODBC compliant database or spreadsheet application like Microsoft Access or Excel.

5.5HotSyncing Data from the PC to the PDA

AccuScan Palm allows you to send databases from the PC directly to your AccuScan Palm sessions on the PDA. Our customers find this an invaluable tool and utilize it many different ways. For example if an inventory control manager needs to distribute pick lists he simply saves the file to the warehouse \ToPDA folder for later import. If a maintenance manager needs to distribute jobs he distributes the job files to the maintenance personnel’s \ToPDA folder. The scenarios in which this feature can be used are limitless!

Many of our customers connect their AccuScan Palm sessions with 3rd-party databases to give their current systems added functionality. By exporting their databases from Microsoft Access and/or Excel these data files can easily be created and distributed.

AccuScan PalmM-0002.010

30

Page 29 Page 31
Image 30
Page 29 Page 31
Contents AccuScan Palm / AccuScan Palm Pro Contents Setting Passwords Installation IntroductionFree Trial Learning AccuScan PalmIntegrating AccuScan Palm POS-X SupportInstalling AccuScan Palm on Multiple PDAs InstallationAutomatic Installation System RequirementsHow to Register Entering Your Registration CodeAccuScan Palm 2.0 Exists as a Separate Application New Location for Uploading Files Removing AccuScan Palm InstallationNew Registration Code Required New Location for Data Files New Name for List Upload FilesConfiguring Session Attributes SessionsSessions General Session Settings Select Session Settings Select the New buttonSession Settings Explained Start On ScreenEdit on scan/Find in grid HotSync SettingsStart On Field Edit on Click in GridData Storage and Transfer Settings Send Non-Visible Fields Backup SettingsAppend to Existing File Include Field NamesBackup Field Hints Backup Session DataBackup Drop-down Lists Deploying Configured Sessions to Multiple UsersField Settings Field SettingsConfiguring Field Settings Select Field Settings Text Field Settings ExplainedField Types Drop-DownCheck Box VariableSignature Pro Version Only General Field SettingsINCR1,1 Data TypeNumeric DefaultGeneral DateShow in Grid CancelVisible Use Popup DialogValidation Field Settings After Scan Field SettingsClear On Submit Update VariablesAuto Submit Auto Find on ScanAllow PC Update Drop-Down ListsModify Field Settings Managing Data Managing DataQuick Buttons How Data Is Sent to the PC Finding DataManaging Data from the PDA to the PC Viewing Data Files on the PCOdbc Link to Data File Linking AccuScan Palm Session Data to an MS Access TableLinking AccuScan Palm Data to an MS Excel Worksheet HotSyncing Data from the PC to the PDACreating Session Data Files with Excel Sending Session Data to the PDA\AccuScan Palm\Data\JohnSmith\ToPDA \Program Files \AccuScan Palm\Data\username\ToPDA\S01dataSending Drop-Down Lists to the PDA Sending Field Hints to the PDA Pro version onlyAdministration Settings Administration SettingsEnable Protection for How to Copy One PDA’s Configuration to Other PDAs File Names Used by AccuScan Palm
Top Page Image Contents