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

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.
 
J

John Nurick

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.
 
G

Guest

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.
 
P

pietlinden

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.... =(
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Import Excel 2010 table into Access 2010 - not listed as range 1
import form excel 3
Browse button for access form 1
Excel "Form" Data into Access 6
Import data from a WORD XP form into an Acccess database 1
Importing from Excel into a Form 1
Dumping Data into an Access Form using Datasheet view 5

Top