Hi, I want to import data from Excel sheet while it is open and not saved,is it possible..
Exactly wht I mean is I m getting data in Excel sheet(use as temp db) from other app. it is not being saved I want to read tht data and insert it into Access DB. and then delete tht Excel sheet data to get another data how to do so plz help me....  

Hi,
You seem to want to IMPORT into Access from Excel, however, would it not be better to EXPORT from Excel into Access - you can use a macro for this and it doesn't require saving your data. If you import into access, you will need a way of detecting which spreadsheet, in which open copy of Excel and which cell that contains your data. Exporting means the user can click a cell in their spreadsheet and click a toolbar button (or run a macro) to dump the data into Access.

The following article is a good (if simple) example. Read through the code and substitute where applicable. For example, you will need to change the db connection, and possibly the starting cell.

Link:
http://www.exceltip.com/st/Export_data_from_Excel_to_Access_(ADO)_using_VBA_in_Microsoft_Excel/425.html
Hope this helps
Kieron


[Edited by stickleprojects on 14-05-2006 at 10:24 PM GMT]

____________________________
Build it better, faster, quicker, easier.. then fix it (non-offical MS mission statement)