How to import a xlsx file for price update

How to import a xlsx file for price update

Excel file fields:

Station column - Text
StationList column - Text
ItemCode column - Text 
ItemName column - Text
Price column - Number
PriceNumber column - Text
WaitForEOD column - Text
ActivateTime column - Custom: d/m/yyyy hh:mm
VatablePrice column - Number

1. Install AccessDatabaseEngine_x64

2. The import works ONLY from the computer running SQL server (RHO), not from clients, unless the import file is placed in a shared folder accessible both to SQL server (RHO) and client and import path is referred as \\share\folder\file and not as local path (if you indicate D:\folder\file will not work). 

3. The sheet name from Excel file must be Prices

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO

sp_configure 'Ad Hoc Distributed Queries', 1;
GO
RECONFIGURE;
GO

EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'AllowInProcess', 1 
GO
EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'DynamicParameters', 1 
GO


    • Related Articles

    • ALL: Exporting and Importing Inventory Items (Codes) from RHO to BOS

      The following procedure can we used when initial inventory items were not replicated or imported correctly during the station installation. If some item codes are missing from the BOS, supplier matrix definitions and price update documents created in ...

    • ALL: Importing DRY inventory taking document from flat file

      In order to import an inventory document in Benzin from a flat file, the following steps need to be taken: 1. Make sure to have InitStock.109 import format file that is used for importing initial stock. It is found in ProMax/EDI/Stg folder: 2. For ...

    • PAIS: Procedure to disable Orpak StoriX Pais Service (ShvaEPS)

      Orpak StoriX Pais Service Removal procedure Errors found in Comserver log Example: 2026/02/10 07:22:00.089|ERROR|[47]|00005574-0000-0000-0000-000000000000|||ComServer.WcfService.WcfCommunicationService - System.ComponentModel.Win32Exception: The ...

    • How to make a trace file on Passport Alpha applications.

      1. Open SQL Profiler application 2. Connect to SQL server on the machine 3. Events selection tab and press Column filters: 4. Here you have 3 columns that needs to be checked: a. Application name b. Binary Data c. ClientProcessID After you check the ...

    • ALL: Tracing Orpak applications on SQL 2008, using SQL Profiler

      Tracing Orpak applications on SQL 2008 using SQL Profiler SQL Server Profiler is a rich interface to create and manage traces and analyze and replay trace results. The events are saved in a trace file that can later be analyzed or used to replay a ...