Need help merging a CSV with SQL data

  • Thread starter Thread starter Dooza
  • Start date Start date
D

Dooza

Hi there,
I have a shop with an e-procurement site that allows me to update a
price list by downloading a CSV file, making the changes, and then
uploading it back into there system.

The CSV file has the following headings:

@UKID - there unique ID for each products
Item Name - the name of the item
Part NO - our unique ID for each product
Price - the price for the product

I have an SQL view that shows our unique ID (Part NO) and the price.

How can I merge the CSV and the SQL view? Our system does not have the
@UKID code, but I don't think it needs it if I can easily merge the 2
together.

Any comments, ideas and criticisms are welcome.

Cheers,

Steve
 
Dooza said:
Hi there,
I have a shop with an e-procurement site that allows me to update a
price list by downloading a CSV file, making the changes, and then
uploading it back into there system.

The CSV file has the following headings:

@UKID - there unique ID for each products
Item Name - the name of the item
Part NO - our unique ID for each product
Price - the price for the product

I have an SQL view that shows our unique ID (Part NO) and the price.

How can I merge the CSV and the SQL view? Our system does not have the
@UKID code, but I don't think it needs it if I can easily merge the 2
together.

Any comments, ideas and criticisms are welcome.
Click to expand...

A vlookup is what I used, never used one before, but it won't be the
last. Documentation is poor, but I got there in the end.

Steve
 
Back
Top