Did you try under Data - Import External Data - New Database Query? You can
generate a macro for importing the data.

I start to record a macro and then import some data and got the following

Sub Macro3()
'
' Macro3 Macro

'

'
With ActiveSheet.QueryTables.Add(Connection:=Array(Arra y( _
"ODBC;DSN=MS Access Database;DBQ=C:\TEMP\PMI Part
Log.mdb;DefaultDir=C:\TEMP;DriverId=25;FIL=MS
Access;MaxBufferSize=2048;PageTimeout" _
), Array("=5;")), Destination:=Range("A1"))
.CommandText = Array( _
"SELECT `IIRM-2 Material Received`.ID, `IIRM-2 Material
Received`.`Procurement Part Number`, `IIRM-2 Material Received`.`Upscreen
Part Number`, `IIRM-2 Material Received`.`Wafer Lot Number1`" & Chr(13) & ""
& Chr(10) & "FROM `C:\" _
, "TEMP\PMI Part Log`.`IIRM-2 Material Received` `IIRM-2 Material
Received`")
.Name = "Query from MS Access Database"
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlInsertDeleteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.PreserveColumnInfo = True
.Refresh BackgroundQuery:=False
End With
End Sub

"Frank Situmorang" wrote:

In excell worksheet there is a cell named: Total Sales which requires data
from Access sales data sales which has the report/form if we run can produce
the total YTD Sales.

My question is how can we link this excell cell to the access total YTD
sales. We know in access can only produce report if we run it, while
we(Budget control Dept) want the data be avaialbe any time. Because Budget
Contorl dept needs their excell worksheet be uptodate anytime (Hotline) We
are using network for this purpose.

We appreciate your idea/help

Frank