Using Excel .xls as an Access DB form...can it be done?

[Abby Lee]

We must use the universities Excel form for travel...so we enter the info to
their form and then our db.

Is there a way to link the Excel form to our Access DB...making it an Access
form. So we can enter the info and then print out the form...the info already
in our DB?
If so where can I get the instructions I need to do this?

 

[Frank Stone]

hi,
I don't think you can link the form but you can link the
exell file to access and use it like a access table.
if your data in the excel file is in the same layout as
your db then you can append the data in the excel file
directly to the db table.
file>get external data>import. this will bring up the
import wizard. in the files of type box, choose excel.
follow the wizards insturctions
hope the helps you.
regards
Frank

 

[Jamie Collins]

We must use the universities Excel form for travel...so
we enter the info to their form and then our db.
Is there a way to link the Excel form to our Access DB

Are you asking if you can update a database from an Excel userform? Of
course, provided you able to capture the form's data and establish a
connection to the database.

A general approach might be: trap an appropriate event in the userform
(e.g. OK button's Click event); validate the data; compile an
appropriate sql statement (e.g. INSERT INTO Claims ...); connect to
the database (e.g. using ADO and the OLD BE provider for Jet); execute
the sql (e.g. ADO Connection object's Execute method); capture the
number of rows affected and any database errors; disconnect from the
database; give feedback on success or otherwise.

Jamie.

--