all

Hey there

I tried to export data from excel to access with the help of sample code given in this site using DAO's and was unsuccessfull. I have added DAO compatable library as adviced. Still I am unable to export data. When i tried to step into the program by pressing F8 ........ it is not reading the declaration part. It is directly going to the while loop and since there the condition is not satisfied and there were no record sets it is coming out of loop and the process is ending there. This is the first time I am writing code to export data. Please do the need full.

Regards
Anuradha.

Hi Anuradha

See this site
http://www.erlandsendata.no/english/...php?t=envbadac


--
Regards Ron de Bruin
http://www.rondebruin.nl


"anuradha" <[email protected]> wrote in message
news:[email protected]...
>
> Hey there
>
> I tried to export data from excel to access with the help of sample
> code given in this site using DAO's and was unsuccessfull. I have added
> DAO compatable library as adviced. Still I am unable to export data.
> When i tried to step into the program by pressing F8 ........ it is not
> reading the declaration part. It is directly going to the while loop and
> since there the condition is not satisfied and there were no record sets
> it is coming out of loop and the process is ending there. This is the
> first time I am writing code to export data. Please do the need full.
>
> Regards
> Anuradha.
>
>
> --
> anuradha
> ------------------------------------------------------------------------
> anuradha's Profile: http://www.excelforum.com/member.php...o&userid=25348
> View this thread: http://www.excelforum.com/showthread...hreadid=388329
>

Hi Ron

Thanks a lot for the link. I have gone through a exceltips.com and wrote a similar program but did not get through. Now I faced another problem . I am writing a VB appication in which I have a populate the combo box with distinct values of a particular field. The project started showing errors when i manually copied and pasted the record from excel sheet to access database. The data base is getting connected and the record set is also giving count. When it comes to Add Item of combo box , The value is shown as null. Awaiting help if you could do.

Thanx
Anuradha.