By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,952 Members | 959 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,952 IT Pros & Developers. It's quick & easy.

Excel Spreadsheet Grid as interface for Access

P: n/a
Hi all.

Wondering if anyone could point me in the direction of resources that
could assist with using a spreadsheet grid in excel as the interface
for dropping values into an Access table. I'm not having much luck
searching the internet.

Basically, I'm after something like this pitiful graphic demonstrates
| 1 | 2 | 3 | 4 | 5 |
----------------------------------
Criteria | X | | | | |
----------------------------------

Basically, when a user puts an X or somehow marks a box in an excel
spreadsheet, this translates to something like this in an access table

Criteria Name | Score
--------------------------
Criteria | 1

If you know what I mean.

Regards
Darragh

Oct 18 '06 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Darragh,

If you are familiar with VBA coding, you can write code to interface
the spreadsheet with Access. If not, I am not sure there is a way. In
any event, if you'd like, I can provide an example of how to do what
you are looking to do. I would be more than happy to send it to you.

Regards,
Brian

Darragh wrote:
Hi all.

Wondering if anyone could point me in the direction of resources that
could assist with using a spreadsheet grid in excel as the interface
for dropping values into an Access table. I'm not having much luck
searching the internet.

Basically, I'm after something like this pitiful graphic demonstrates
| 1 | 2 | 3 | 4 | 5 |
----------------------------------
Criteria | X | | | | |
----------------------------------

Basically, when a user puts an X or somehow marks a box in an excel
spreadsheet, this translates to something like this in an access table

Criteria Name | Score
--------------------------
Criteria | 1

If you know what I mean.

Regards
Darragh
Oct 18 '06 #2

P: n/a
Hi Brian, can you send the example to me please. If not to much trouble. i
can see myself needing to do something like this :)

billjonesparis AT Yahoo DOT com

Cheers
>If you are familiar with VBA coding, you can write code to interface
the spreadsheet with Access. If not, I am not sure there is a way. In
any event, if you'd like, I can provide an example of how to do what
you are looking to do. I would be more than happy to send it to you.
--
Regan,
Paeroa
World famous in New Zealand

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200610/1

Oct 18 '06 #3

P: n/a
Brian

Thanks for your reply - I would be very interested in your example. Is
it possible for you to email it to me?

Regards
Darragh

Brian Puffer wrote:
Darragh,

If you are familiar with VBA coding, you can write code to interface
the spreadsheet with Access. If not, I am not sure there is a way. In
any event, if you'd like, I can provide an example of how to do what
you are looking to do. I would be more than happy to send it to you.

Regards,
Brian

Darragh wrote:
Hi all.

Wondering if anyone could point me in the direction of resources that
could assist with using a spreadsheet grid in excel as the interface
for dropping values into an Access table. I'm not having much luck
searching the internet.

Basically, I'm after something like this pitiful graphic demonstrates
| 1 | 2 | 3 | 4 | 5 |
----------------------------------
Criteria | X | | | | |
----------------------------------

Basically, when a user puts an X or somehow marks a box in an excel
spreadsheet, this translates to something like this in an access table

Criteria Name | Score
--------------------------
Criteria | 1

If you know what I mean.

Regards
Darragh
Oct 23 '06 #4

P: n/a
Darragh,

Sorry I have been so long in getting back to you! I had to send the
email to da************@gmail.com instead of the yahoo account. It was
returned to me as undeliverable.

Regards,
Brian

Darragh wrote:
Brian

Thanks for your reply - I would be very interested in your example. Is
it possible for you to email it to me?

Regards
Darragh

Brian Puffer wrote:
Darragh,

If you are familiar with VBA coding, you can write code to interface
the spreadsheet with Access. If not, I am not sure there is a way. In
any event, if you'd like, I can provide an example of how to do what
you are looking to do. I would be more than happy to send it to you.

Regards,
Brian

Darragh wrote:
Hi all.
>
Wondering if anyone could point me in the direction of resources that
could assist with using a spreadsheet grid in excel as the interface
for dropping values into an Access table. I'm not having much luck
searching the internet.
>
Basically, I'm after something like this pitiful graphic demonstrates
| 1 | 2 | 3 | 4 | 5 |
----------------------------------
Criteria | X | | | | |
----------------------------------
>
Basically, when a user puts an X or somehow marks a box in an excel
spreadsheet, this translates to something like this in an access table
>
Criteria Name | Score
--------------------------
Criteria | 1
>
If you know what I mean.
>
Regards
Darragh
Oct 24 '06 #5

P: n/a
Brian

that yahoo account wasn't me.

But I got your example, and it has proved very very helpful. Many
thanks!

Darragh

Brian Puffer wrote:
Darragh,

Sorry I have been so long in getting back to you! I had to send the
email to da************@gmail.com instead of the yahoo account. It was
returned to me as undeliverable.

Regards,
Brian

Darragh wrote:
Brian

Thanks for your reply - I would be very interested in your example. Is
it possible for you to email it to me?

Regards
Darragh

Brian Puffer wrote:
Darragh,
>
If you are familiar with VBA coding, you can write code to interface
the spreadsheet with Access. If not, I am not sure there is a way. In
any event, if you'd like, I can provide an example of how to do what
you are looking to do. I would be more than happy to send it to you.
>
Regards,
Brian
>
Darragh wrote:
Hi all.

Wondering if anyone could point me in the direction of resources that
could assist with using a spreadsheet grid in excel as the interface
for dropping values into an Access table. I'm not having much luck
searching the internet.

Basically, I'm after something like this pitiful graphic demonstrates
| 1 | 2 | 3 | 4 | 5 |
----------------------------------
Criteria | X | | | | |
----------------------------------

Basically, when a user puts an X or somehow marks a box in an excel
spreadsheet, this translates to something like this in an access table

Criteria Name | Score
--------------------------
Criteria | 1

If you know what I mean.

Regards
Darragh
Oct 26 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.