excel to access

[leah f via AccessMonster.com]

When a client transfers some access fields to excel, works with them and
then changes some of the data, is there any way the client can transfer the
data back to access (2002)?

 

[Guest]

yes there is.
inport from excel then use an update query to update the
table with new data.
but the first think that popped into my head when i read
you post was....why is the client making changes to the
data OUTSIDE of access?!?!?!?

 

[ruthness]

what I usually did is doing tat in the code
loop thru the row and column and save it to the db.
this is what I did:

Do While vLastShipDate < Date
For i = vRow To vMaxRow
vPartId = oSheet.Cells(i, vCol)
vQty = oSheet.Cells(i, vCol + 1)
stSql = "SELECT * FROM trShipHeader, trShipDetail WHERE " &
_
"trShipHeader.recHeaderId = trShipDetail.HeaderRecId
AND " & _
"shipDate = " & FormatDateJET(vLastShipDate) & _
" AND partid = '" & CStr(vPartId) & "'"

rs.Open stSql, cn, adOpenForwardOnly, adLockReadOnly
If Not rs.EOF Then
oSheet.Cells(i, vCol + 1) = vQty - rs.Fields("qty")
End If
rs.Close
Next
vLastShipDate = vLastShipDate + 1
Loop