import an Excel "form" into an Access "form"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have read several other questions about inputting an Excel spreadsheet(laid
out as a form) into an Access table BUT I have not seen any question on this
subject.

Just curious, Is there anyway (I mean anyway, even if it involves
third-party software like Crystal Reports or Monarch) to import an excel
spreadsheet, that is laid out like an input form, into a form in Access (not
a table). I realize that all access forms MUST have a table behind it to
store the data. What I am thinking of is somehow importing the excel "form"
as an Access form template devoid of table fields. Then I would manually put
the table fields into the form and create a table linked to each of these
form fields.

If I can't do this, then I will have to manually create about 40 different
forms in Access that I already have as templates in Excel. That would be a
bummer.
 
Hi Anthony,

How about taking a screenshot of each Excel "form" and use the
resulting images on Access forms?

In principle you could write code that collects information on the
location and dimensions of every relevant thing on the Excel sheet and
then automates Access to create a lookalike form - but sooner you than
me.
 
Thanks. Doing what you say is probably about as easy as just recreating the
40 forms in Access from scratch. That is, if I understand what you are
saying. I was hoping it could be more automated. I guess I am asking Access
to do something it really wasn't designed to do.
 
Thanks. Doing what you say is probably about as easy as just recreating the
40 forms in Access from scratch. That is, if I understand what you are
saying. I was hoping it could be more automated. I guess I am asking Access
to do something it really wasn't designed to do.
Click to expand...

You probably are... but then I'm not an Excel expert, either. You
could write some code that would automate the import of the data from
your excel files into Access, but that's about the best you would get,
I think. At least that way, the _data_ is in Access. The forms you
would very likely just have to rebuild.... =(
 
Back
Top