flat import file

[pinbrook]

I thought that it was possible to create an import file with just product reference number and price.

The product ref no being the unique identifier for a quick price change routine.

On importing my 2 column csv, actinic says I have to use section name also so it knows where to put things....

is this true? how do i get round this, as this will takes ages!

[wjcampbe]

Jo, can you run the froogle extract, then import into excel, delete the columns you don't need. Make your changes then save as a csv from excel. I have not tried it but it sounds feasible.

[pinbrook]

Good Idea Bill, but v5 doesn't have the froogle export prog.

Although I could use Jan's Mash - which i will if Actinic confirm that I have to use section names

[Jan]

You definately need the section names in a flat import file. You can use a hierarchical import file with just the product reference and price thought - you might need to wrap a dummy section around it.

The easiest way to write a bit of SQL to do the update and make the change in access.

Regards,

[pinbrook]

The easiest way to write a bit of SQL

HoHo!! Good idea if I could do SQL....maybe my SQL for dummys is going to come out of the cupboard

[pinbrook]

Ok a plea to database/SQL bods...

This is what I want to do

I have a csv file with 2 cols prodref

using access how do I link to this file, join it to the product table on prod ref and write the csv price to the product table

TIA