Report from .CSV query ?

[losdamianos]

HI all !
Ok here is the story.
I have created simple database for the warehouse where each SKU has unique location.
Everyday I get mail with the orders with 10-15 SKU`s (each order) and I need to find locations for them. Well Im doing it manually and it takes just too long. Is there any way to speed up this process ?
I was thinking of asking the sales department for the .CSV file so I could export it ( just the SKU`s) and then based on that I could match the SKU`s with the location and create report.

I know Im not supposed to say that but Im relatively new to ACCESS.
Any help Really appriciated.

Damian

 

[Trevor G]

HI all !
Ok here is the story.
I have created simple database for the warehouse where each SKU has unique location.
Everyday I get mail with the orders with 10-15 SKU`s (each order) and I need to find locations for them. Well Im doing it manually and it takes just too long. Is there any way to speed up this process ?
I was thinking of asking the sales department for the .CSV file so I could export it ( just the SKU`s) and then based on that I could match the SKU`s with the location and create report.

I know Im not supposed to say that but Im relatively new to ACCESS.
Any help Really appriciated.

Damian

Welcome to the forum,

If you can get the relevant data download then upload into your database as a separate table you could then use a lookup wizard to establish the location based on the SKU number.