$$Excel-Macros$$ Re: Excel and Access connectivity

Hi, You can use DAO or ADODB to connect excel and access. For your referance : http://doc.ddart.net/mssql/sql2000/html/mdacxml/htm/wpmigratingopening.htm http://www.winsoft.sk/daofaq.htm http://vbatalent.blogspot.com/2009/05/create-select-query-using-sql-in-vba.html Regards Rakesh On Jul 27, 9

$$Excel-Macros$$ Re: Excel and Access connectivity

Hi Sunil, You can link your worksheet with MS-Access and then write Queries rather than importing data from Excel to Access. Regards, Upendra Singh +91-9910227325, +91-9310760597 - The