Is it possible to make an excel spreadsheet an access form?

[gearhead03]

I have an excel spreadsheet that is an inspection form for trucks we have. Is it possible to make it an access report to make printing the reports out easier? Can it be imported into access?

Mark A. Kale

 

[SkipVought]

Hi,

How would one be easier to print than the other.

Skip,
[sub]
Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty![/sub]

 

[gearhead03]

because we have 15 trucks. Instead of C&P all the information for each truck into excel's cells I can setup an access report to click one button and print them all at one time.

Mark A. Kale

 

[dhookom]

You can set up tables in Excel and create reports. Since we don't have a clue what your Excel reports look like or even if they contain data, we can't be of much greater assistance.


Duane MS Access MVP
Now help me support United Cerebral Palsy

 

[SkipVought]

"...Instead of C&P all the information ..."

Where did copy and paste come from? You asked about printing reports.

Where is the data? Where is the report? We cannot see into your head. Surely you do not copy and paste data from 15 different sources?

Skip,
[sub]
Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty![/sub]

 

[gearhead03]

Sorry,

Currently I have an Access 2000 database with a table full of trucks; Vin numbers, makes, models, unit#s etc.
I also have an excel spreadsheet that is an inspection form. Right now I convert the truck table to excel and then C&P the information into the inspection form. I would like to make the inspection form an access report to make it a simple button click to print all the inspection forms out at one time. I CAN rebuild the form but I would rather not if I don't have to.

Thanks for your help!

Mark A. Kale

 

[dhookom]

I don't believe there is any way to take the layout of an Excel spreadsheet and "paste" or otherwise import it into an Access report. I'm not sure what the holdup would be in creating an Access report either from scratch or following the results of the report wizard.

Duane MS Access MVP
Now help me support United Cerebral Palsy

 

[SkipVought]

"I convert the truck table to excel and then C&P the information into the inspection form."

You could quite easily, without too much change to your current process, QUERY the access database rather than C & P, to get the data into Excel. Then it ought to be some simple mapping of data to your "form"

Data > Import External Data > New Database Query -- ACCESS DB... Post in Forum68 if you need more help with this approch.



Skip,
[sub]
Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty![/sub]

 

[gearhead03]

Thanks for your help.

I may work with the query in excel but I am more familiar with access. I guess I will just create the report. I can do it but was hoping there an easier way to do it because the report has lots of small blocks on it that will make it time consuming to make.

Mark A. Kale

 

[skyline666]

Hi gearhead03,

I think making a report in Access straight from the table would be easier then putting all your data into Excel first, as when you go in the design wizard, you can choose which table to make the report on, what fields to choose etc. Also, you said changing the design would be time consuming, yes it would first of all, but when it is done, you can reuse it as many times as you want if you save the report, and also if you like that style that you made, then you can reuse that style by copy and pasting the report into the report section (to make a new report), and then just change the fields that you want to change to make a new report.

Andrew