hi,
Access will recognize a named range in excel as a linked table and can be
used in access to write queries, reports ect. you would need a macro in excel
to resize the named range as you enter data and once resized, the data
automaticly shows up in access.

Regards
FSt1

"Michael Kintner" wrote:

I am trying to use Excel as the input area and then post the data into
Access. I have seperate fields in tables as well as sheets of data entry.

Mike

"reachkars" wrote in message
oups.com...
On Jun 11, 3:09 pm, "Michael Kintner" wrote:
Does anybody have any examples for keying data into excel and have it
update
an Microsoft Access database on the fly?

Thank you in advance for any help,
Michael Kintner

Are you trying to enter data in a excel spreadsheet & transfer the
same to a access table & then then fetch it from the access table &
populate the excel sheet??