Convert an Excel Sheet to an Access Form

  • Thread starter Thread starter Thorrrr
  • Start date Start date
T

Thorrrr

Hi

I have quite a complex excel spread sheet that works out numerous dates and
times over multiple ranges in relation to user input so ever rersult wil be
different.

I wanted to import all the funcionality from Excel into a form in Access i
ahve tried but the functions do not come across or work.

Is there an easier way to get it working?
 
Thorrrr said:
Hi

I have quite a complex excel spread sheet that works out numerous
dates and times over multiple ranges in relation to user input so
ever rersult wil be different.

I wanted to import all the funcionality from Excel into a form in
Access i ahve tried but the functions do not come across or work.

Is there an easier way to get it working?
Click to expand...

Sorry no easy way I know. You will need to recreate the calculations in
Access. Likely you will want to use a query, but there are options on forms
and reports as needed. What's best depends on your particulars.
 
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

Excel Monthly Spread sheet. 12
Set the Column/Length format on an Excell sheet 8
Help with Importing from Excel into Access 0
Import from an excel sheet 4
Excel sheet in Access Form 2
Excel VBA - Problem with Closing Print Preview 0
Link Access to Excel export back to excel 3
Creating an Excel Spreadsheet from Access 1

Back
Top