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

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