Is it possible to bring data from excel into access only when I want!
I have linked a excel sheet into access but it's getting slowly the base!
I think if I have opened the excel data into access only when I really want it wouldn't be slow!
Maybe with a button I could see the data only when I want!

I would be grateful if you could help me!

Yes.

I would suggest TransferSpreadsheet and put it in a table when needed. That way you only squirt the back end when you want the data, and never create a persistent connection. This means that the functions would be:

DoCmd.OpenQuery (delete query) to remove current data from table.
DoCmd.TransferSpreadsheet (Or database?) to pull data from the spreadsheet.

Did this help?


mmcdonal

Thanks mmcdonal, but the thing it's more complicated!
I've linked the spreddsheet cause I want to be on real time!
I'm taking two fields(with numbers)-(from the linked sheet), continuasly I'm making a query where I sum the two fields.
And in one form xxx, I've brought a subform yyy (the query), to show me the results!
First problem: I can't when I'm opening the real .xls to open the form xxx
Second problem: I can't see the results of the form xxx on the second pc (there two pc connected), when it's already opened in the first pc!

This I'm really trying is in both computer to see the query of the form xxx at the same time, moreover don't getting too late!

I didn't understand where should I type the
DoCmd.OpenQuery
DoCmd.TransferSpreadsheet

and if I won't link the .xls table how could I brought the data of it?

Thank you once again!

Well you have two contradictory issues here.

IF when you open the form you can't open the spreadsheet, then why have the connection in real time? If the spreadsheet will remain closed when you access the data anyway, why not just import it?

Anyway, on the other questions:

You need to create a table that can accept the data from the spreadsheet.
Then when you pull data from the spreadsheet, you need to have a delete query that runs first to get rid of any old data in the table.
Then transfer in the data from the spreadsheet.

So if you created a delete query called "qryDELETEOldData" your code would look something like:

DoCmd.SetWarnings False
DoCmd.OpenQuery "qryDELETEOldData"
DoCmd.TransferSpreadsheet (look up syntax)
DoCmd.SetWarnings True
DoCmd.OpenForm "frmYourFormXXX", etc



mmcdonal