import excel form which is not linear into access

[Nurse Nancy]

I have a form with column headings and data all over the place and some
merged cells,,,, Is there anyway to import this into access, or what do i
need to do to it in order to import.

The admin person for this company just created the form this week and has
not sent it out yet to the customers to gather info. Should I ask them to
change the format of the form?

Also they do not have outlook,, is there still a way to automatically send
and receive the form data?

thanks
nancy

 

[pietlinden]

I have a form with column headings and data all over the place and some
merged cells,,,, Is there anyway to import this into access, or what do i
need to do to it in order to import.

The admin person for this company just created the form this week and has
not sent it out yet to the customers to gather info.  Should I ask themto
change the format of the form?

Also they do not have outlook,, is there still a way to automatically send
and receive the form data?

thanks
nancy

My 2 cents, but if you are stuck with non-columnar data, I would
either restructure your spreadsheet, and if necessary, add bookmarks
for the non-columnar oddballs. Then you can use the bookmark name to
refer to the values. If you use the Excel object model, you can
reference all these fun things...

 

[Nurse Nancy]

Wow, never heard or the bookmarks,,, i have to leave the form as is,, since
it gets sent out to the customers for now.

I'll have to look into the bookmarks
thanks much!--
Nancy