Reading Updates From A File

[dhstein]

We have a table containing the following fields:

WarehouseLocID (PK)
WarehouseID (Defines which Warehouse a product is in)
WarehouseLoc (Location within the warehouse - e.g. bin location)
WarehouseLocProdID (Defines a Product from the Product Table)
WarehouseLocSKU (Product SKU of the Product)
WarehouseLocQTY (quantity of the product at this location)


Daily we will get 2 excel files which contain WarehouseID, WarehouseLocSKU,
and Quantity - 1 file is quantity sold - 1 file is quantity received. We
want to apply these updates to the Quantity field

Questions:

1) We will put a header record on the files and want to validate the header
before processing the updates - does that mean we shouldn't use the Excel
format and should create the file as straight text instead? What would be
easier?

2) Any comments or opinions on how to process this would be appreciated.
Thanks

 

[Tom van Stiphout]

On Tue, 25 Nov 2008 19:58:02 -0800, dhstein

Before I continue reading: if you've already defined
WarehouseLocProdID, why also use WarehouseLocSKU in this table?
dpesn't the ID value tell you what the SKU value would be?

-Tom.
Microsoft Access MVP

 

[dhstein]

On Tue, 25 Nov 2008 19:58:02 -0800, dhstein

Before I continue reading: if you've already defined
WarehouseLocProdID, why also use WarehouseLocSKU in this table?
dpesn't the ID value tell you what the SKU value would be?

-Tom.
Microsoft Access MVP


Tom, you are correct. I'm still working through parts of this design and learning as I go.