In excel i have a column
A cell 1
B cell 2
C cell 3
D cell 4
E cell 5
F cell 6
G cell 7
In Access
A 1
B 2
C 3
D 4
E 5
F 6
G 7
. .
. .
. .
I would like to populate cell 1, cell 2, ... with values 1,2,3... from the access database. I would like the criteria for the query in access to be A, B, C.... from excel.
It seems to me that I should be able to do this through MS query, but im not sure how to specify the criteria. Or then again, maybe i am on the wrong tract.
Any help is greatly appreciated!
Ed
A cell 1
B cell 2
C cell 3
D cell 4
E cell 5
F cell 6
G cell 7
In Access
A 1
B 2
C 3
D 4
E 5
F 6
G 7
. .
. .
. .
I would like to populate cell 1, cell 2, ... with values 1,2,3... from the access database. I would like the criteria for the query in access to be A, B, C.... from excel.
It seems to me that I should be able to do this through MS query, but im not sure how to specify the criteria. Or then again, maybe i am on the wrong tract.
Any help is greatly appreciated!
Ed