Access Or Excel help please
19 December 2002, 03:37 PM
#1
Scooby Regular
Thread Starter
Join Date: Aug 2001
Location: wakefield
Posts: 2,082
Likes: 0
Received 0 Likes
on
0 Posts
I need to read from 2 .xls (or.csv) files that contain data & query then replace with a different set of data from the other file.....
file 1 has 2 columns: display name & mail address
file 2 has 90 columns that are e-mail group names, under these columns are display names that match file 1...
I need to replace all the display names in file 2 under the group columns with the full a-mail address from file 1 column 2
hope you all understood that.
any help appreciated on this one please
shunty
file 1 has 2 columns: display name & mail address
file 2 has 90 columns that are e-mail group names, under these columns are display names that match file 1...
I need to replace all the display names in file 2 under the group columns with the full a-mail address from file 1 column 2
hope you all understood that.
any help appreciated on this one please
shunty
...is it something nice James?
19 December 2002, 03:55 PM
#4
Moderator
Join Date: Dec 1998
Location: Staffs
Posts: 23,573
Likes: 0
Received 0 Likes
on
0 Posts
Import both files into Access.
New query, join the tables on the indentical fields but only show / output the two columns you want.
Export the query results to CSV.
Sorted.
New query, join the tables on the indentical fields but only show / output the two columns you want.
Export the query results to CSV.
Sorted.
Trending Topics
19 December 2002, 04:19 PM
#9
Scooby Regular
Thread Starter
Join Date: Aug 2001
Location: wakefield
Posts: 2,082
Likes: 0
Received 0 Likes
on
0 Posts
really, you not interested in these types of films ??
the first 1 was a bit long & slow in parts, but the reviews on the second 1 seem to be a lot more action...
anyway, c ya later, I'm sure you got loads of moderating to do
shunty
the first 1 was a bit long & slow in parts, but the reviews on the second 1 seem to be a lot more action...
anyway, c ya later, I'm sure you got loads of moderating to do
shunty
Thread
Thread Starter
Forum
Replies
Last Post
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
28 December 2015 11:07 PM
Mattybr5@MB Developments
Full Cars Breaking For Spares
12
18 November 2015 07:03 AM