i need to create a feature in excel where i can merge two csv files, based on
a key field in both files, ie where smith in file a matches smith in file b,
then take the 4th value from file b and add it to the third value in file A.

very relational.

given i've only got excel and vba and 2 csv files to do this in whats the
best way of going about it, architecturally speaking!!

How do I post a question when I can't get the Subject box and Message boxes
to appear on the screen? I'm at wits end on this.
Mikey

"Jono2000" wrote:

i need to create a feature in excel where i can merge two csv files, based on
a key field in both files, ie where smith in file a matches smith in file b,
then take the 4th value from file b and add it to the third value in file A.

very relational.

given i've only got excel and vba and 2 csv files to do this in whats the
best way of going about it, architecturally speaking!!

Use msquery in Excel if you just want to display the results. If you want
to alter the values in file A, then I guess you would need to go to ADO or
you could import the files into excel and manipulate them there or use low
level file io, but either of the latter two do not take advantage of
relational capabilities.

--
Regards,
Tom Ogilvy


"Jono2000" wrote in message
...
i need to create a feature in excel where i can merge two csv files, based
on
a key field in both files, ie where smith in file a matches smith in file
b,
then take the 4th value from file b and add it to the third value in file
A.

very relational.

given i've only got excel and vba and 2 csv files to do this in whats the
best way of going about it, architecturally speaking!!

ok - I've now found Microsoft Query and built the relevant queries in basic
sql which solves my requests.

"Jono2000" wrote:

i need to create a feature in excel where i can merge two csv files, based on
a key field in both files, ie where smith in file a matches smith in file b,
then take the 4th value from file b and add it to the third value in file A.

very relational.

given i've only got excel and vba and 2 csv files to do this in whats the
best way of going about it, architecturally speaking!!