Report

[Luis]

Hello.
I have a .xls file that i'd like to use as a report on a
Access 2000 db. Is it possible to import the file as a
report?

 

[Rick B]

What do you mean "import a spreadsheet as a report"? Do you want to import
the data from the spreadsheet into a table in Access and then report off the
table?

If not, I don't understand why you would not just print it from Excel..

Give us some more details here.

Rick B


Hello.
I have a .xls file that i'd like to use as a report on a
Access 2000 db. Is it possible to import the file as a
report?

 

[Luis]

Ok, let's try to clarify.
Someone sent me a template in xls format. The information
to fill this template is stored in a access table.
What i'd like to do, if possible, is to use the template
on the database, otherwise i have to export the table to
Excel and build a macro to automate the filling process.
The original table has 1200 records and the template only
aallows 16 records per page.