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

Have you tried the

Microsoft Add in that can do the exporting for you?

http://www.microsoft.com/downloads/d...displaylang=EN



"RK" wrote in message
...
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

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