We have an existing excel spread sheet which is updated every month with new
prices, and would like to integrate with an Access database.  We need to
collect info from the furthest right cell with info in it in the excel spread
sheet and put it into a query.  Any suggestions?

I am trying to close a subform within a mainform so I can extract datat to
SAS and send it back to repopulate the table with new data. I need the syntax
to close the subform. Here is what I am using to close teh main form
tname = [Form_main].RecordSource

I have read many threads about how to convert Date from YYYYMMDD to
DD/MM/YYYY format, can anyone help me to do the reverse? That is, I have some
Date data like 27/05/1979 and I want convert it to 19790527. Is this
operation possible in Access or Excel? Thanks in advance.

I have an Access2000 App that links in an Excel 2003 worksheet.  When I
attempt to update the linked table I get the message "This table is not
updateable". I have encountered this before with a local table where a query
had a one to many relationship and there was no primary key ...