Question about dates and Excel in Access

[nilses]

Hello,

I would like to create a function which counts the number of day between two dates without counting saturdays and Sundays and I would like also a function which counts the number of Saturday between two dates. Could you help me to build these functions?

I have another question, my second question is about access and Excel. I use Excel to see data of Access because I have too many data. Is it possible to open an Excel sheet in access without opening Excel?.

Thank you

nillse

 

[Travis]

First Question:

Look at this Previous Posting

Count Work Days


Second Qustion:
I'm not sure I understood you correctly. Do you want to View the data in an Access File using Excel?

Most situation I know of want to view the Excel data from Access.

 

[Mile-O]

If your table is set out well then you can link the spreadsheet into the database as if it were a table.

 

[nilses]

Thanks Travis and Mile-O-Phile for your answer.

My question is perhaps stupid but yes i would like view a data sheet from excel to access. is is possible to make this?.

Thanks

Nilses

 

[Travis]

You can link an Excel Sheet to an access database. Then create a DataSheet form off of the Excel Sheet's Table.