Excel to Access

R

RK

I have 45 spreadsheets that are setup like forms. Is there a tool that can create Access reports from these spreadsheets
The built in Excel report tool creates the speadsheet into an OLE (Picture)

Thank you RK
 
R

RK

David
This just maintains Access as the front end with excel as the backend. I thought it was an easy task for what I wanted to do in Excel. But it has turned out that I am unable to get answers that can help. So what I would like to do is create an Access database and import all my Excel stuff. 90% is converted, but the one part that is critical only converts to an OLE. I spent many many hours creating all the different spreadsheets and the basic layout and design I would like to convert into an Access database withut having to spend many many hours all over again

Thank you for your help
RK
 
Top