Excel to Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A negative to using Application.Onkey 6
Recording a macro 3
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
How do you embed Access Report in Excel? 3
Click on a hyperlink to hide or show a spreadsheet 4
export to excel with format 1
Excel Access - importing an excel spreadsheet 0
Query Data in Excel S/S from Access DB 2

Back
Top