Import MS Access table in Excel

[vijay2482]

i would like to know is it possible to import MS Access table in Excel spreadsheet using VBA code???
if possible, kindly help me to do so.......

thanks in advance

[Kenneth Hobson]

Start here: http://www.erlandsendata.no/english/...php?t=envbadac

[vijay2482]

thanks a lot...
will check out

[Shijesh Kumar]

One way to get ms access data is doing the following..

open and excel sheet.
click on data menu --> Get External Data --> New Data base query

Select MS Access Database file and follow the instruction...

[vijay2482]

im not sure,where to and how to use the example codes?????????
http://www.erlandsendata.no/english/...php?t=envbadac
im very confused.....

i want to use the Ms Access to excel and Text to excel separatly for 2 different workbooks......
any help to do this????????

thanks