Excel to Access

  • Thread starter Thread starter RK
  • Start date Start date
R

RK

I have used Excel to design a form for data input. But I
want to create an Access database (for obvious reasons).
The primary reason I started out with Excel was that I
was able to use Excel to design a Form the way I wanted
and could place the data in the form and it would print
the way it looked on a screen.
I have created 50 of these Excel spreadsheets. Is there a
way that I could convert the Excel spreadsheets designs
to an Access report? The current tool in Access creates
an OLE (picture) that can't be edited.

Thank you for any suggestions.
 
RK:

There's no conversion tool to move the forms (which are based on MS Forms 2)
to an Access form; you have to pretty much design from scratch. On the
other hand if you have a lot of code behind your report, you can without too
much changing move that to an Access form although the object model is a bit
different for form objects.
 
Back
Top